DBA Data[Home] [Help]

APPS.CST_DIAGNOSTICS_PKG dependencies on WIP_MOVE_TXN_INTERFACE

Line 161: FROM wip_move_txn_interface WMTI

157: -- Added for bug 4256685
158: OR MMT.MOVE_TRANSACTION_ID = MMTP.move_transaction_id)
159: UNION ALL
160: SELECT null
161: FROM wip_move_txn_interface WMTI
162: WHERE MMT.transaction_action_id IN (30, 31)
163: AND WMTI.TRANSACTION_ID = MMT.MOVE_TRANSACTION_ID
164: )
165: )

Line 314: FROM wip_move_txn_interface WMTI

310: -- Added for bug 4256685
311: OR MMT.MOVE_TRANSACTION_ID = MMTP.move_transaction_id)
312: UNION ALL
313: SELECT null
314: FROM wip_move_txn_interface WMTI
315: WHERE MMT.transaction_action_id IN (30, 31)
316: AND WMTI.TRANSACTION_ID = MMT.MOVE_TRANSACTION_ID
317: )
318: )

Line 849: FROM WIP_MOVE_TXN_INTERFACE WMTI

845: END IF;
846:
847: SELECT COUNT(1)
848: INTO L_WMTI_COUNT
849: FROM WIP_MOVE_TXN_INTERFACE WMTI
850: WHERE WMTI.TRANSACTION_ID = L_TXN_MOVE_TXN_ID ;
851: IF (L_WMTI_COUNT > 0) THEN
852:
853: INSERT INTO CST_DIAG_TXN_ERRORS(TRANSACTION_ID,