DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_ITEM_INSTANCES_H

Line 4318: FROM csi_item_instances_h cih,

4314: IS
4315:
4316: CURSOR txn_cur(p_instance_id in number) IS
4317: SELECT ct.transaction_type_id
4318: FROM csi_item_instances_h cih,
4319: csi_transactions ct
4320: WHERE cih.instance_id = p_instance_id
4321: AND ct.transaction_id = cih.transaction_id
4322: AND NOT (ct.transaction_type_id = 51 AND ct.source_header_ref_id = p_header_id)