VIEW: APPS.CST_XLA_INTERORG_PARAMS_REF_V

Source

View Text - Preformatted

SELECT /*+ cardinality(xgt,1) */ 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 /*+ CARDINALITY(XGT
, 1) */ 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 ) )