VIEW: APPS.CHV_ORG_OPTIONS_V

Source

View Text - Preformatted

SELECT COO.ROWID , COO.ORGANIZATION_ID, MTP.ORGANIZATION_CODE , HOU.NAME , COO.ENABLE_CUM_FLAG , COO.RTV_UPDATE_CUM_FLAG , COO.LAST_UPDATE_DATE , COO.LAST_UPDATED_BY , COO.CREATION_DATE , COO.CREATED_BY , COO.PLAN_BUCKET_PATTERN_ID, CBP.BUCKET_PATTERN_NAME , COO.SHIP_BUCKET_PATTERN_ID , CBP1.BUCKET_PATTERN_NAME , COO.PLAN_SCHEDULE_TYPE , PLC.DISPLAYED_FIELD , COO.SHIP_SCHEDULE_TYPE , PLC1.DISPLAYED_FIELD , COO.MRP_COMPILE_DESIGNATOR , NVL(MP1.DESCRIPTION, DES1.DESCRIPTION), COO.MPS_SCHEDULE_DESIGNATOR , NVL(MP2.DESCRIPTION, DES2.DESCRIPTION), COO.DRP_COMPILE_DESIGNATOR , NVL(MP3.DESCRIPTION, DES3.DESCRIPTION), COO.ATTRIBUTE_CATEGORY , COO.ATTRIBUTE1 , COO.ATTRIBUTE2 , COO.ATTRIBUTE3 , COO.ATTRIBUTE4 , COO.ATTRIBUTE5 , COO.ATTRIBUTE6 , COO.ATTRIBUTE7, COO.ATTRIBUTE8 , COO.ATTRIBUTE9 , COO.ATTRIBUTE10 , COO.ATTRIBUTE11 , COO.ATTRIBUTE12 , COO.ATTRIBUTE13 , COO.ATTRIBUTE14 , COO.ATTRIBUTE15 , COO.LAST_UPDATE_LOGIN , COO.REQUEST_ID , COO.PROGRAM_APPLICATION_ID, COO.PROGRAM_ID , COO.PROGRAM_UPDATE_DATE FROM MTL_PARAMETERS MTP , CHV_ORG_OPTIONS COO, HR_ORGANIZATION_UNITS HOU , PO_LOOKUP_CODES PLC, PO_LOOKUP_CODES PLC1 , CHV_BUCKET_PATTERNS CBP, CHV_BUCKET_PATTERNS CBP1 , MRP_PLANS MP1, MRP_DESIGNATORS DES1, MRP_PLANS MP2, MRP_DESIGNATORS DES2, MRP_PLANS MP3, MRP_DESIGNATORS DES3 WHERE COO.ORGANIZATION_ID = HOU.ORGANIZATION_ID(+) AND COO.ORGANIZATION_ID = MTP.ORGANIZATION_ID AND COO.PLAN_SCHEDULE_TYPE = PLC.LOOKUP_CODE (+) AND 'PLAN_SCHEDULE_SUBTYPE' = PLC.LOOKUP_TYPE (+) AND COO.SHIP_SCHEDULE_TYPE = PLC1.LOOKUP_CODE (+) AND 'SHIP_SCHEDULE_SUBTYPE' = PLC1.LOOKUP_TYPE (+) AND COO.PLAN_BUCKET_PATTERN_ID = CBP.BUCKET_PATTERN_ID (+) AND COO.SHIP_BUCKET_PATTERN_ID = CBP1.BUCKET_PATTERN_ID (+) AND COO.ORGANIZATION_ID = DES1.ORGANIZATION_ID(+) AND COO.MRP_COMPILE_DESIGNATOR = DES1.COMPILE_DESIGNATOR (+) AND COO.ORGANIZATION_ID = DES2.ORGANIZATION_ID(+) AND COO.MPS_SCHEDULE_DESIGNATOR = DES2.COMPILE_DESIGNATOR (+) AND COO.ORGANIZATION_ID = DES3.ORGANIZATION_ID(+) AND COO.DRP_COMPILE_DESIGNATOR = DES3.COMPILE_DESIGNATOR (+) AND COO.ORGANIZATION_ID = MP1.ORGANIZATION_ID(+) AND COO.MRP_COMPILE_DESIGNATOR = MP1.COMPILE_DESIGNATOR (+) AND COO.ORGANIZATION_ID = MP2.ORGANIZATION_ID(+) AND COO.MPS_SCHEDULE_DESIGNATOR = MP2.COMPILE_DESIGNATOR (+) AND COO.ORGANIZATION_ID = MP3.ORGANIZATION_ID(+) AND COO.DRP_COMPILE_DESIGNATOR = MP3.COMPILE_DESIGNATOR (+)

View Text - HTML Formatted

SELECT COO.ROWID
, COO.ORGANIZATION_ID
, MTP.ORGANIZATION_CODE
, HOU.NAME
, COO.ENABLE_CUM_FLAG
, COO.RTV_UPDATE_CUM_FLAG
, COO.LAST_UPDATE_DATE
, COO.LAST_UPDATED_BY
, COO.CREATION_DATE
, COO.CREATED_BY
, COO.PLAN_BUCKET_PATTERN_ID
, CBP.BUCKET_PATTERN_NAME
, COO.SHIP_BUCKET_PATTERN_ID
, CBP1.BUCKET_PATTERN_NAME
, COO.PLAN_SCHEDULE_TYPE
, PLC.DISPLAYED_FIELD
, COO.SHIP_SCHEDULE_TYPE
, PLC1.DISPLAYED_FIELD
, COO.MRP_COMPILE_DESIGNATOR
, NVL(MP1.DESCRIPTION
, DES1.DESCRIPTION)
, COO.MPS_SCHEDULE_DESIGNATOR
, NVL(MP2.DESCRIPTION
, DES2.DESCRIPTION)
, COO.DRP_COMPILE_DESIGNATOR
, NVL(MP3.DESCRIPTION
, DES3.DESCRIPTION)
, COO.ATTRIBUTE_CATEGORY
, COO.ATTRIBUTE1
, COO.ATTRIBUTE2
, COO.ATTRIBUTE3
, COO.ATTRIBUTE4
, COO.ATTRIBUTE5
, COO.ATTRIBUTE6
, COO.ATTRIBUTE7
, COO.ATTRIBUTE8
, COO.ATTRIBUTE9
, COO.ATTRIBUTE10
, COO.ATTRIBUTE11
, COO.ATTRIBUTE12
, COO.ATTRIBUTE13
, COO.ATTRIBUTE14
, COO.ATTRIBUTE15
, COO.LAST_UPDATE_LOGIN
, COO.REQUEST_ID
, COO.PROGRAM_APPLICATION_ID
, COO.PROGRAM_ID
, COO.PROGRAM_UPDATE_DATE
FROM MTL_PARAMETERS MTP
, CHV_ORG_OPTIONS COO
, HR_ORGANIZATION_UNITS HOU
, PO_LOOKUP_CODES PLC
, PO_LOOKUP_CODES PLC1
, CHV_BUCKET_PATTERNS CBP
, CHV_BUCKET_PATTERNS CBP1
, MRP_PLANS MP1
, MRP_DESIGNATORS DES1
, MRP_PLANS MP2
, MRP_DESIGNATORS DES2
, MRP_PLANS MP3
, MRP_DESIGNATORS DES3
WHERE COO.ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)
AND COO.ORGANIZATION_ID = MTP.ORGANIZATION_ID
AND COO.PLAN_SCHEDULE_TYPE = PLC.LOOKUP_CODE (+)
AND 'PLAN_SCHEDULE_SUBTYPE' = PLC.LOOKUP_TYPE (+)
AND COO.SHIP_SCHEDULE_TYPE = PLC1.LOOKUP_CODE (+)
AND 'SHIP_SCHEDULE_SUBTYPE' = PLC1.LOOKUP_TYPE (+)
AND COO.PLAN_BUCKET_PATTERN_ID = CBP.BUCKET_PATTERN_ID (+)
AND COO.SHIP_BUCKET_PATTERN_ID = CBP1.BUCKET_PATTERN_ID (+)
AND COO.ORGANIZATION_ID = DES1.ORGANIZATION_ID(+)
AND COO.MRP_COMPILE_DESIGNATOR = DES1.COMPILE_DESIGNATOR (+)
AND COO.ORGANIZATION_ID = DES2.ORGANIZATION_ID(+)
AND COO.MPS_SCHEDULE_DESIGNATOR = DES2.COMPILE_DESIGNATOR (+)
AND COO.ORGANIZATION_ID = DES3.ORGANIZATION_ID(+)
AND COO.DRP_COMPILE_DESIGNATOR = DES3.COMPILE_DESIGNATOR (+)
AND COO.ORGANIZATION_ID = MP1.ORGANIZATION_ID(+)
AND COO.MRP_COMPILE_DESIGNATOR = MP1.COMPILE_DESIGNATOR (+)
AND COO.ORGANIZATION_ID = MP2.ORGANIZATION_ID(+)
AND COO.MPS_SCHEDULE_DESIGNATOR = MP2.COMPILE_DESIGNATOR (+)
AND COO.ORGANIZATION_ID = MP3.ORGANIZATION_ID(+)
AND COO.DRP_COMPILE_DESIGNATOR = MP3.COMPILE_DESIGNATOR (+)