APPS.CSI_ML_UTIL_PVT dependencies on PO_VENDORS

Line 278: FROM po_vendors

274: CLOSE pty1_intf_cur;
275:
276: UPDATE CSI_I_PARTY_INTERFACE cpi
277: SET party_id=(SELECT vendor_id
278: FROM po_vendors
279: WHERE vendor_name = cpi.party_name
280: )
281: WHERE cpi.party_source_table = 'PO_VENDORS'
282: AND cpi.inst_interface_id IN (SELECT inst_interface_id

Line 281: WHERE cpi.party_source_table = 'PO_VENDORS'

277: SET party_id=(SELECT vendor_id
278: FROM po_vendors
279: WHERE vendor_name = cpi.party_name
280: )
281: WHERE cpi.party_source_table = 'PO_VENDORS'
282: AND cpi.inst_interface_id IN (SELECT inst_interface_id
283: FROM csi_instance_interface cii
284: WHERE cii.transaction_identifier IS NOT NULL
285: AND trunc(source_transaction_date)

Line 804: FROM po_vendors

800: COMMIT;
801: CLOSE pty1_intf_cur;
802: UPDATE CSI_I_PARTY_INTERFACE cpi
803: SET party_id=(SELECT vendor_id
804: FROM po_vendors
805: WHERE vendor_name = cpi.party_name)
806: WHERE cpi.party_source_table = 'PO_VENDORS'
807: AND cpi.inst_interface_id IN (SELECT inst_interface_Id
808: FROM csi_instance_interface

Line 806: WHERE cpi.party_source_table = 'PO_VENDORS'

802: UPDATE CSI_I_PARTY_INTERFACE cpi
803: SET party_id=(SELECT vendor_id
804: FROM po_vendors
805: WHERE vendor_name = cpi.party_name)
806: WHERE cpi.party_source_table = 'PO_VENDORS'
807: AND cpi.inst_interface_id IN (SELECT inst_interface_Id
808: FROM csi_instance_interface
809: WHERE transaction_identifier IS NULL
810: AND trunc(source_transaction_date)

Line 1156: FROM po_vendors

1152: CLOSE pty1_intf_cur;
1153:
1154: UPDATE CSI_I_PARTY_INTERFACE cpi
1155: SET party_id = (SELECT vendor_id
1156: FROM po_vendors
1157: WHERE vendor_name = cpi.party_name)
1158: WHERE cpi.inst_interface_id IN (SELECT inst_interface_id
1159: FROM csi_instance_interface cii
1160: WHERE cii.transaction_identifier = p_txn_identifier)

Line 1161: AND cpi.party_source_table = 'PO_VENDORS'

1157: WHERE vendor_name = cpi.party_name)
1158: WHERE cpi.inst_interface_id IN (SELECT inst_interface_id
1159: FROM csi_instance_interface cii
1160: WHERE cii.transaction_identifier = p_txn_identifier)
1161: AND cpi.party_source_table = 'PO_VENDORS'
1162: AND cpi.party_id IS NULL
1163: AND cpi.party_name IS NOT NULL;
1164:
1165: UPDATE CSI_I_PARTY_INTERFACE cpi