View: CST_XLA_INTERORG_PARAMS_REF_V

Product:	BOM - Bills of Material
Description:	Inter organization GL Accounts for AX backward compatibility
Implementation/DBA Data:	APPS.CST_XLA_INTERORG_PARAMS_REF_V

View Text

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))

Columns