APPS.INV_DS_LOGICAL_TRX_INFO_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 73: FROM MTL_MATERIAL_TRANSACTIONS

69: intercompany_cost,intercompany_pricing_option,
70: trx_flow_header_id,logical_transactions_created,
71: logical_transaction,intercompany_currency_code
72:
73: FROM MTL_MATERIAL_TRANSACTIONS
74: WHERE TRANSACTION_ACTION_ID NOT IN (24,30) AND
75: (transaction_id = p_transaction_id)
76:
77: UNION

Line 85: FROM MTL_MATERIAL_TRANSACTIONS

81: parent_transaction_id,logical_trx_type_code,
82: intercompany_cost,intercompany_pricing_option,
83: trx_flow_header_id,logical_transactions_created,
84: logical_transaction,intercompany_currency_code
85: FROM MTL_MATERIAL_TRANSACTIONS
86: WHERE TRANSACTION_ACTION_ID NOT IN (24,30) AND
87: ( PARENT_TRANSACTION_ID IN
88: (SELECT PARENT_TRANSACTION_ID FROM MTL_MATERIAL_TRANSACTIONS
89: WHERE TRANSACTION_ACTION_ID NOT IN (24,30) AND

Line 88: (SELECT PARENT_TRANSACTION_ID FROM MTL_MATERIAL_TRANSACTIONS

84: logical_transaction,intercompany_currency_code
85: FROM MTL_MATERIAL_TRANSACTIONS
86: WHERE TRANSACTION_ACTION_ID NOT IN (24,30) AND
87: ( PARENT_TRANSACTION_ID IN
88: (SELECT PARENT_TRANSACTION_ID FROM MTL_MATERIAL_TRANSACTIONS
89: WHERE TRANSACTION_ACTION_ID NOT IN (24,30) AND
90: (transaction_id = p_transaction_id)) AND
91: PARENT_TRANSACTION_ID IS NOT NULL);
92: