VIEW: APPS.CSTBV_MANUFACTURING_ACTIVITIES

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ CA.ACTIVITY_ID , CA.ORGANIZATION_ID /* REGULAR ATTRIBUTES */ , CA.ACTIVITY , CA.DESCRIPTION , '_LA:ca.default_basis_type:MFG_LOOKUPS:CST_BASIS:MEANING' , CA.DISABLE_DATE , CA.OUTPUT_UOM , CA.VALUE_ADDED_ACTIVITY_FLAG /* FOREIGN KEYS RESOLVED */ , MP.ORGANIZATION_CODE , HR.NAME /* IDS */ /* WHO */ , CA.CREATION_DATE , CA.CREATED_BY , CA.LAST_UPDATE_DATE , CA.LAST_UPDATED_BY FROM HR_ALL_ORGANIZATION_UNITS HR ,MTL_PARAMETERS MP ,CST_ACTIVITIES CA WHERE CA.ORGANIZATION_ID = HR.ORGANIZATION_ID(+) AND CA.ORGANIZATION_ID = MP.ORGANIZATION_ID(+) AND '_SEC:ca.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ CA.ACTIVITY_ID
, CA.ORGANIZATION_ID /* REGULAR ATTRIBUTES */
, CA.ACTIVITY
, CA.DESCRIPTION
, '_LA:CA.DEFAULT_BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, CA.DISABLE_DATE
, CA.OUTPUT_UOM
, CA.VALUE_ADDED_ACTIVITY_FLAG /* FOREIGN KEYS RESOLVED */
, MP.ORGANIZATION_CODE
, HR.NAME /* IDS */ /* WHO */
, CA.CREATION_DATE
, CA.CREATED_BY
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, CST_ACTIVITIES CA
WHERE CA.ORGANIZATION_ID = HR.ORGANIZATION_ID(+)
AND CA.ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND '_SEC:CA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY