DBA Data[Home] [Help]

APPS.CST_DIAGNOSTICS_PKG dependencies on MTL_CST_TXN_COST_DETAILS

Line 889: FROM MTL_CST_TXN_COST_DETAILS MCTCD

885: FROM CST_DIAG_ERRORED_TXNS SC
886: WHERE SC.TRANSACTION_ACTION_ID IN (12,21)
887: AND SC.SHIPMENT_COSTED IS NULL
888: AND EXISTS ( SELECT 'X'
889: FROM MTL_CST_TXN_COST_DETAILS MCTCD
890: WHERE MCTCD.TRANSACTION_ID = SC.BOTTLE_NECK_TXN_ID
891: AND MCTCD.ORGANIZATION_ID = SC.ORGANIZATION_ID
892: )
893: AND SC.BOTTLE_NECK_TXN_ID IS NOT NULL