View: CHV_ORG_OPTIONS_V

Product:	CHV - Supplier Scheduling
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CHV_ORG_OPTIONS_V

View Text

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 (+)

Columns