APPS.QA_SKIPLOT_RES_ENGINE dependencies on RCV_TRANSACTIONS

Line 71: FROM rcv_transactions_interface

67: -- kabalakr Wed Oct 29 23:19:22 PST 2003.
68:
69: CURSOR int_txn (grp_id NUMBER, txn_id NUMBER) IS
70: SELECT max(interface_transaction_id)
71: FROM rcv_transactions_interface
72: WHERE group_id = grp_id
73: AND parent_transaction_id = txn_id;
74:
75: l_rti_int_txn_id NUMBER;

Line 675: from rcv_transactions

671: p_reinsp_flag out NOCOPY varchar2) is
672:
673: cursor txn_type (x_txn_id in number) is
674: select transaction_type
675: from rcv_transactions
676: where transaction_id = x_txn_id;
677:
678: begin
679:

Line 863: ' from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh ' ||

859: --
860: if p_rma_id is not null and p_rma_id > 0 then
861: shls_query :=
862: ' select distinct rs.shipment_line_id ' ||
863: ' from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh ' ||
864: ' where rsh.receipt_source_code = ''CUSTOMER'' ' ||
865: ' and rs.oe_order_header_id = :1 ' ||
866: ' and rs.to_organization_id = :2 ' ||
867: ' and rs.item_id = :3 ' ||

Line 886: ' from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh ' ||

882: --
883: elsif p_int_ship_id is not null and p_int_ship_id > 0 then
884: shls_query :=
885: ' select distinct rs.shipment_line_id ' ||
886: ' from rcv_supply rs, rcv_transactions rt, rcv_shipment_headers rsh ' ||
887: ' where rsh.receipt_source_code <> ''VENDOR'' ' ||
888: ' and rs.shipment_header_id = :1 ' ||
889: ' and rs.to_organization_id = :2 ' ||
890: ' and rs.item_id = :3 ' ||

Line 910: ' rcv_transactions rt, ' ||

906: elsif p_receipt_num is not null then
907: shls_query :=
908: ' select distinct rsl.shipment_line_id ' ||
909: ' from rcv_supply rs, ' ||
910: ' rcv_transactions rt, ' ||
911: ' rcv_shipment_headers rsh, ' ||
912: ' rcv_shipment_lines rsl ' ||
913: ' where rsh.receipt_num = :1 ' ||
914: ' and rsh.shipment_header_id = rs.shipment_header_id ' ||

Line 931: ' FROM rcv_supply rs, rcv_transactions rt, po_headers ph ' ||

927: --
928: else
929: shls_query :=
930: ' SELECT distinct rs.shipment_line_id ' ||
931: ' FROM rcv_supply rs, rcv_transactions rt, po_headers ph ' ||
932: ' WHERE rs.rcv_transaction_id = rt.transaction_id ' ||
933: ' AND rs.po_header_id = ph.po_header_id ' ||
934: ' AND ph.segment1 = :1 ' ||
935: ' AND rs.to_organization_id = :2 ' ||

Line 976: from rcv_transactions

972: p_rej_qty out NOCOPY number) is
973:
974: cursor get_coll_id (x_txn_id in number) is
975: select qa_collection_id
976: from rcv_transactions
977: where transaction_id = x_txn_id;
978:
979: coll_id number;
980: result varchar2(100);