VIEW: APPS.GMF_XLA_ORG_PARAMETERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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