VIEW: APPS.CST_XLA_INV_ORG_PARAMS_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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