View: GMF_XLA_ORG_PARAMETERS_V

Product:	GMF - Process Manufacturing Financials
Description:	View for SLA ADR sources from Inventory Organization parameters.
Implementation/DBA Data:	APPS.GMF_XLA_ORG_PARAMETERS_V

View Text

SELECT MP1.ORGANIZATION_ID
, MP1.ORGANIZATION_CODE ORGANIZATION_CODE
, MP_MST.ORGANIZATION_CODE MASTER_ORGANIZATION_CODE
, NVL(MP1.CONSIGNED_FLAG
, 'N') CONSIGNED_FLAG
, NVL(MP1.WMS_ENABLED_FLAG
, 'N') WMS_ENABLED_FLAG
, MP1.PURCHASE_PRICE_VAR_ACCOUNT ORG_PARAM_PPV_ACCOUNT
, MP1.AP_ACCRUAL_ACCOUNT ORG_PARAM_AP_ACCRUAL_ACCOUNT
, MP1.INTRANSIT_INV_ACCOUNT ORG_PARAM_ITR_ACCOUNT
, MP1.INTERORG_RECEIVABLES_ACCOUNT ORG_PARAM_IOR_ACCOUNT
, MP1.INTERORG_PAYABLES_ACCOUNT ORG_PARAM_IOP_ACCOUNT
, MP1.COST_OF_SALES_ACCOUNT ORG_PARAM_COGS_ACCOUNT
, MP1.INTERORG_TRANSFER_CR_ACCOUNT ORG_PARAM_XFER_CREDIT_ACCOUNT
, MP1.INVOICE_PRICE_VAR_ACCOUNT ORG_PARAM_IPV_ACCOUNT
, MP1.EXPENSE_ACCOUNT ORG_PARAM_EXPENSE_ACCOUNT
, MP1.DISTRIBUTION_ACCOUNT_ID ORG_PARAM_DISTR_ACCOUNT_ID
, MP1.DEFERRED_COGS_ACCOUNT ORG_PARAM_DCOGS_ACCOUNT
, MP1.ATTRIBUTE_CATEGORY INV_ORG_ATTRIBUTE_CATEGORY
, MP1.ATTRIBUTE1 INV_ORG_ATTRIBUTE1
, MP1.ATTRIBUTE2 INV_ORG_ATTRIBUTE2
, MP1.ATTRIBUTE3 INV_ORG_ATTRIBUTE3
, MP1.ATTRIBUTE4 INV_ORG_ATTRIBUTE4
, MP1.ATTRIBUTE5 INV_ORG_ATTRIBUTE5
, MP1.ATTRIBUTE6 INV_ORG_ATTRIBUTE6
, MP1.ATTRIBUTE7 INV_ORG_ATTRIBUTE7
, MP1.ATTRIBUTE8 INV_ORG_ATTRIBUTE8
, MP1.ATTRIBUTE9 INV_ORG_ATTRIBUTE9
, MP1.ATTRIBUTE10 INV_ORG_ATTRIBUTE10
, MP1.ATTRIBUTE11 INV_ORG_ATTRIBUTE11
, MP1.ATTRIBUTE12 INV_ORG_ATTRIBUTE12
, MP1.ATTRIBUTE13 INV_ORG_ATTRIBUTE13
, MP1.ATTRIBUTE14 INV_ORG_ATTRIBUTE14
, MP1.ATTRIBUTE15 INV_ORG_ATTRIBUTE15
FROM MTL_PARAMETERS MP1
, (SELECT ORGANIZATION_ID
, ORGANIZATION_CODE
FROM MTL_PARAMETERS
WHERE ORGANIZATION_ID = MASTER_ORGANIZATION_ID) MP_MST
WHERE MP1.PROCESS_ENABLED_FLAG = 'Y'
AND MP_MST.ORGANIZATION_ID = MP1.MASTER_ORGANIZATION_ID

Columns