Product: | BOM - Bills of Material |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CST_XLA_INV_ORG_PARAMS_REF_V |
SELECT MP1.ORGANIZATION_ID INV_ORGANIZATION_ID
, MP1.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
, MP1.PRIMARY_COST_METHOD PRIMARY_COST_METHOD
, MP1.COST_ORGANIZATION_ID COST_ORGANIZATION_ID
, MP1.MAINT_ORGANIZATION_ID MAINT_ORGANIZATION_ID
, DECODE(MP1.PROJECT_REFERENCE_ENABLED
, 1
, 'Y'
, 'N' ) PROJECT_REFERENCE_ENABLED
, DECODE(MP1.PM_COST_COLLECTION_ENABLED
, 1
, 'Y'
, 'N' ) PM_COST_COLLECTION_ENABLED
, MP1.PROJECT_CONTROL_LEVEL PROJECT_CONTROL_LEVEL
, MP1.AVG_RATES_COST_TYPE_ID AVG_RATES_COST_TYPE_ID
, CT.COST_TYPE AVG_RATES_COST_TYPE
, DECODE(CT.BOM_SNAPSHOT_FLAG
, 1
, 'Y'
, 'N' ) BOM_SNAPSHOT_FLAG
, DECODE(CT.ALLOW_UPDATES_FLAG
, 1
, 'Y'
, 'N' ) ALLOW_UPDATES_FLAG
, DECODE(CT.AVAILABLE_TO_ENG_FLAG
, 1
, 'Y'
, 'N' ) AVAILABLE_TO_ENG_FLAG
, NVL(MP1.PROCESS_ENABLED_FLAG
, 'N') PROCESS_ENABLED_FLAG
, NVL(MP1.WSM_ENABLED_FLAG
, 'N') WSM_ENABLED_FLAG
, NVL(MP1.WMS_ENABLED_FLAG
, 'N') WMS_ENABLED_FLAG
, NVL(MP1.EAM_ENABLED_FLAG
, 'N') EAM_ENABLED_FLAG
, NVL(MP1.CONSIGNED_FLAG
, 'N') CONSIGNED_ORG_FLAG
, NVL(MP1.WCS_ENABLED
, 'N') WCS_ENABLED
, DECODE(MP1.DEFER_LOGICAL_TRANSACTIONS
, 1
, 'Y'
, 'N' ) DEFER_LOGICAL_TRANSACTIONS
, DECODE(MP1.COST_GROUP_ACCOUNTING
, 1
, 'Y'
, 'N' ) COST_GROUP_ACCOUNTING
, MP1.COST_CUTOFF_DATE COST_CUTOFF_DATE
, DECODE(MP1.ENCUMBRANCE_REVERSAL_FLAG
, 1
, 'Y'
, 'N' ) ENCUMBRANCE_REVERSAL_FLAG
, MP1.ATTRIBUTE_CATEGORY ORG_INV_ATTRIBUTE_CATEGORY
, MP1.ATTRIBUTE1 ORG_INV_ATTRIBUTE1
, MP1.ATTRIBUTE2 ORG_INV_ATTRIBUTE2
, MP1.ATTRIBUTE3 ORG_INV_ATTRIBUTE3
, MP1.ATTRIBUTE4 ORG_INV_ATTRIBUTE4
, MP1.ATTRIBUTE5 ORG_INV_ATTRIBUTE5
, MP1.ATTRIBUTE6 ORG_INV_ATTRIBUTE6
, MP1.ATTRIBUTE7 ORG_INV_ATTRIBUTE7
, MP1.ATTRIBUTE8 ORG_INV_ATTRIBUTE8
, MP1.ATTRIBUTE9 ORG_INV_ATTRIBUTE9
, MP1.ATTRIBUTE10 ORG_INV_ATTRIBUTE10
, MP1.ATTRIBUTE11 ORG_INV_ATTRIBUTE11
, MP1.ATTRIBUTE12 ORG_INV_ATTRIBUTE12
, MP1.ATTRIBUTE13 ORG_INV_ATTRIBUTE13
, MP1.ATTRIBUTE14 ORG_INV_ATTRIBUTE14
, MP1.ATTRIBUTE15 ORG_INV_ATTRIBUTE15
, MP1.AVERAGE_COST_VAR_ACCOUNT INV_ORG_AVG_COST_VAR_ACCT
, MP1.PURCHASE_PRICE_VAR_ACCOUNT INV_ORG_PUR_PRICE_VAR_ACCT
, TO_NUMBER(MP1.ATTRIBUTE9) INV_ORG_EXPENSE_ACCT
FROM MTL_PARAMETERS MP1
, CST_COST_TYPES CT
WHERE CT.COST_TYPE_ID(+) = MP1.AVG_RATES_COST_TYPE_ID