Monday, October 23, 2017

Query to get Order Source Details in Oracle Apps

SELECT OOS.NAME             "Order Import Source"
       ,OOS.DESCRIPTION      "Description"
       ,OOS.ENABLED_FLAG     "Enabled"
       ,OOS.AIA_ENABLED_FLAG "AIA Enabled"
FROM   APPS.OE_ORDER_SOURCES OOS
WHERE  1=1
AND    EXISTS (SELECT 1 FROM APPS.FND_USER WHERE USER_ID = OOS.CREATED_BY)

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)