View: MTL_TRANSACTION_FLOWS_V

Product:	INV - Inventory
Description:	MTL_TRANSACTION_FLOWS_V is a view for Intercompany transaction flows of type shipping and procuring flows.
Implementation/DBA Data:	APPS.MTL_TRANSACTION_FLOWS_V

View Text

SELECT H.HEADER_ID
, H.START_ORG_ID
, H.END_ORG_ID
, L.LINE_NUMBER
, L.FROM_ORG_ID
, L.TO_ORG_ID
, H.FLOW_TYPE
, H.ORGANIZATION_ID
, H.QUALIFIER_CODE
, H.QUALIFIER_VALUE_ID
, H.START_DATE
, H.END_DATE
, H.ASSET_ITEM_PRICING_OPTION
, H.EXPENSE_ITEM_PRICING_OPTION
, L.FROM_ORGANIZATION_ID
, L.TO_ORGANIZATION_ID
, IC.CUSTOMER_ID
, IC.ADDRESS_ID
, IC.CUSTOMER_SITE_ID
, IC.CUST_TRX_TYPE_ID
, IC.VENDOR_ID
, IC.VENDOR_SITE_ID
, IC.FREIGHT_CODE_COMBINATION_ID
, IC.INVENTORY_ACCRUAL_ACCOUNT_ID
, IC.EXPENSE_ACCRUAL_ACCOUNT_ID
, IC.INTERCOMPANY_COGS_ACCOUNT_ID
, H.NEW_ACCOUNTING_FLAG
, IC.INV_CURRENCY_CODE
FROM MTL_TRANSACTION_FLOW_HEADERS H
, MTL_TRANSACTION_FLOW_LINES L
, MTL_INTERCOMPANY_PARAMETERS IC
WHERE H.HEADER_ID = L.HEADER_ID
AND L.FROM_ORG_ID = IC.SHIP_ORGANIZATION_ID
AND L.TO_ORG_ID = IC.SELL_ORGANIZATION_ID
AND H.FLOW_TYPE = IC.FLOW_TYPE

Columns