eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.CST_XLA_INTERORG_PARAMS_REF_V

Source

View Text - Preformatted


SELECT iorgp.FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID, iorgp.TO_ORGANIZATION_ID TO_ORGANIZATION_ID, iorgp.INTRANSIT_INV_ACCOUNT INTERORG_TXFR_DEBIT_ACCOUNT, iorgp.INTERORG_TRANSFER_CR_ACCOUNT INTERORG_TXFR_CREDIT_ACCOUNT, iorgp.INTERORG_RECEIVABLES_ACCOUNT INTERORG_RECEIVABLES_ACCOUNT , iorgp.INTERORG_PAYABLES_ACCOUNT INTERORG_PAYABLES_ACCOUNT, iorgp.INTERORG_PRICE_VAR_ACCOUNT INTERORG_PRICE_VAR_ACCOUNT, iorgp.PROFIT_IN_INV_ACCOUNT PROFIT_IN_INV_ACCOUNT, iorgp.INTERORG_PROFIT_ACCOUNT INTERORG_PROFIT_ACCOUNT, to_number(iorgp.ATTRIBUTE8) INTERORG_BRIDGING_ACCOUNT, to_number(iorgp.ATTRIBUTE9) INTERORG_EXPENSE_ACCOUNT, to_number(iorgp.ATTRIBUTE10) INTERORG_REVENUE_ACCOUNT, h.event_id FROM xla_events_gt xgt, CST_XLA_INV_HEADERS_V h, MTL_INTERORG_PARAMETERS iorgp WHERE xgt.event_id = h.event_id AND ( ( xgt.event_class_code = 'INT_ORDER_TO_EXP' AND (( /*Receipt */ iorgp.from_organization_id = h.transfer_organization_id AND iorgp.to_organization_id = h.organization_id AND h.transaction_action_id = 17 ) OR ( /*issue*/ iorgp.from_organization_id = h.organization_id AND iorgp.to_organization_id = h.transfer_organization_id AND h.transaction_action_id = 1))) OR ( ( (xgt.event_class_code IN ('DIR_INTERORG_RCPT', 'FOB_SHIP_RECIPIENT_RCPT', 'FOB_RCPT_RECIPIENT_RCPT', 'FOB_SHIP_RECIPIENT_SHIP')) /*User Defined transactions*/ OR ( xgt.event_class_code = 'USER_DEFINE' AND xgt.event_type_code IN ('UDIR_INTERORG_RCPT', 'UDIR_INTERORG_RCPT_NO_TP', 'UDIR_INTERORG_RCPT_TP', 'UFOB_SHIP_RECIPIENT_SHIP_TP', 'UFOB_SHIP_RECIPIENT_SHIP_NO_TP'))) AND iorgp.FROM_ORGANIZATION_ID = h.transfer_organization_id AND iorgp.to_organization_id = h.organization_id) OR ( ( xgt.event_class_code IN ('FOB_RCPT_SENDER_RCPT', 'FOB_SHIP_SENDER_SHIP', 'DIR_INTERORG_SHIP', 'FOB_RCPT_SENDER_SHIP') /*User Defined transactions*/ OR ( xgt.event_class_code = 'USER_DEFINE' AND xgt.event_type_code IN ('UDIR_INTERORG_SHIP', 'UDIR_INTERORG_SHIP_NO_TP', 'UDIR_INTERORG_SHIP_TP', 'UFOB_SHIP_SENDER_SHIP_TP', 'UFOB_SHIP_SENDER_SHIP_NO_TP', 'UFOB_RCPT_SENDER_SHIP'))) AND iorgp.FROM_ORGANIZATION_ID = h.organization_id AND iorgp.to_organization_id = h.transfer_organization_id))

View Text - HTML Formatted

SELECT IORGP.FROM_ORGANIZATION_ID FROM_ORGANIZATION_ID
, IORGP.TO_ORGANIZATION_ID TO_ORGANIZATION_ID
, IORGP.INTRANSIT_INV_ACCOUNT INTERORG_TXFR_DEBIT_ACCOUNT
, IORGP.INTERORG_TRANSFER_CR_ACCOUNT INTERORG_TXFR_CREDIT_ACCOUNT
, IORGP.INTERORG_RECEIVABLES_ACCOUNT INTERORG_RECEIVABLES_ACCOUNT
, IORGP.INTERORG_PAYABLES_ACCOUNT INTERORG_PAYABLES_ACCOUNT
, IORGP.INTERORG_PRICE_VAR_ACCOUNT INTERORG_PRICE_VAR_ACCOUNT
, IORGP.PROFIT_IN_INV_ACCOUNT PROFIT_IN_INV_ACCOUNT
, IORGP.INTERORG_PROFIT_ACCOUNT INTERORG_PROFIT_ACCOUNT
, TO_NUMBER(IORGP.ATTRIBUTE8) INTERORG_BRIDGING_ACCOUNT
, TO_NUMBER(IORGP.ATTRIBUTE9) INTERORG_EXPENSE_ACCOUNT
, TO_NUMBER(IORGP.ATTRIBUTE10) INTERORG_REVENUE_ACCOUNT
, H.EVENT_ID
FROM XLA_EVENTS_GT XGT
, CST_XLA_INV_HEADERS_V H
, MTL_INTERORG_PARAMETERS IORGP
WHERE XGT.EVENT_ID = H.EVENT_ID
AND ( ( XGT.EVENT_CLASS_CODE = 'INT_ORDER_TO_EXP'
AND (( /*RECEIPT */ IORGP.FROM_ORGANIZATION_ID = H.TRANSFER_ORGANIZATION_ID
AND IORGP.TO_ORGANIZATION_ID = H.ORGANIZATION_ID
AND H.TRANSACTION_ACTION_ID = 17 ) OR ( /*ISSUE*/ IORGP.FROM_ORGANIZATION_ID = H.ORGANIZATION_ID
AND IORGP.TO_ORGANIZATION_ID = H.TRANSFER_ORGANIZATION_ID
AND H.TRANSACTION_ACTION_ID = 1))) OR ( ( (XGT.EVENT_CLASS_CODE IN ('DIR_INTERORG_RCPT'
, 'FOB_SHIP_RECIPIENT_RCPT'
, 'FOB_RCPT_RECIPIENT_RCPT'
, 'FOB_SHIP_RECIPIENT_SHIP')) /*USER DEFINED TRANSACTIONS*/ OR ( XGT.EVENT_CLASS_CODE = 'USER_DEFINE'
AND XGT.EVENT_TYPE_CODE IN ('UDIR_INTERORG_RCPT'
, 'UDIR_INTERORG_RCPT_NO_TP'
, 'UDIR_INTERORG_RCPT_TP'
, 'UFOB_SHIP_RECIPIENT_SHIP_TP'
, 'UFOB_SHIP_RECIPIENT_SHIP_NO_TP')))
AND IORGP.FROM_ORGANIZATION_ID = H.TRANSFER_ORGANIZATION_ID
AND IORGP.TO_ORGANIZATION_ID = H.ORGANIZATION_ID) OR ( ( XGT.EVENT_CLASS_CODE IN ('FOB_RCPT_SENDER_RCPT'
, 'FOB_SHIP_SENDER_SHIP'
, 'DIR_INTERORG_SHIP'
, 'FOB_RCPT_SENDER_SHIP') /*USER DEFINED TRANSACTIONS*/ OR ( XGT.EVENT_CLASS_CODE = 'USER_DEFINE'
AND XGT.EVENT_TYPE_CODE IN ('UDIR_INTERORG_SHIP'
, 'UDIR_INTERORG_SHIP_NO_TP'
, 'UDIR_INTERORG_SHIP_TP'
, 'UFOB_SHIP_SENDER_SHIP_TP'
, 'UFOB_SHIP_SENDER_SHIP_NO_TP'
, 'UFOB_RCPT_SENDER_SHIP')))
AND IORGP.FROM_ORGANIZATION_ID = H.ORGANIZATION_ID
AND IORGP.TO_ORGANIZATION_ID = H.TRANSFER_ORGANIZATION_ID))