Product: | GMF - Process Manufacturing Financials |
---|---|
Description: | View for SLA ADR sources from Subinventory definition |
Implementation/DBA Data: | APPS.GMF_XLA_SUBINV_V |
SELECT ORGANIZATION_ID ORGANIZATION_ID
, ORGANIZATION_ID SUBINV_ORGANIZATION_ID
, SECONDARY_INVENTORY_NAME SUBINVENTORY_CODE
, DECODE(ASSET_INVENTORY
, 1
, 'Y'
, 'N' ) SUBINV_ASSET_FLAG
, SUBINVENTORY_TYPE SUBINVENTORY_TYPE
, LOCATOR_TYPE SUBINV_LOCATOR_TYPE
, EXPENSE_ACCOUNT SUBINV_EXPENSE_ACCOUNT
, MATERIAL_ACCOUNT SUBINV_MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT SUBINV_MATERIAL_OVH_ACCOUNT
, RESOURCE_ACCOUNT SUBINV_RESOURCE_ACCOUNT
, OVERHEAD_ACCOUNT SUBINV_OVERHEAD_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT SUBINV_OSP_ACCOUNT
, ENCUMBRANCE_ACCOUNT SUBINV_ENCUMBRANCE_ACCOUNT
FROM MTL_SECONDARY_INVENTORIES SUBINV