Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTBV_MANUFACTURING_ACTIVITIES |
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