VIEW: APPS.MTL_TRANSACTION_FLOWS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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