APPS.RCV_RECEIPT_CONFIRMATION dependencies on RCV_SHIPMENT_HEADERS

Line 34: FROM rcv_shipment_headers rsh,

30:
31:
32: CURSOR get_rcv_headers_1(l_trx_date_from DATE, l_trx_date_to DATE) IS
33: SELECT distinct rsh.shipment_header_id
34: FROM rcv_shipment_headers rsh,
35: rcv_shipment_lines rsl,
36: rcv_transactions rt
37: WHERE rsh.ship_to_org_id = p_org_id
38: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code

Line 60: FROM rcv_shipment_headers rsh,

56: ) order by shipment_header_id asc;
57:
58: CURSOR get_rcv_headers_2(l_trx_date_from DATE, l_trx_date_to DATE) IS
59: SELECT distinct rsh.shipment_header_id
60: FROM rcv_shipment_headers rsh,
61: rcv_shipment_lines rsl,
62: rcv_transactions rt
63: WHERE rsh.ship_to_org_id = p_org_id
64: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code

Line 86: FROM rcv_shipment_headers rsh,

82: ) order by shipment_header_id asc;
83:
84: CURSOR get_rcv_headers_3(l_trx_date_from DATE, l_trx_date_to DATE) IS
85: SELECT distinct rsh.shipment_header_id
86: FROM rcv_shipment_headers rsh,
87: rcv_transactions rt
88: WHERE rsh.ship_to_org_id = p_org_id
89: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
90: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)

Line 109: FROM rcv_shipment_headers rsh,

105: ) order by shipment_header_id asc;
106:
107: CURSOR get_rcv_headers_4(l_trx_date_from DATE, l_trx_date_to DATE) IS
108: SELECT distinct rsh.shipment_header_id
109: FROM rcv_shipment_headers rsh,
110: rcv_transactions rt
111: WHERE rsh.ship_to_org_id = p_org_id
112: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)
113: AND rsh.shipment_header_id BETWEEN nvl(p_shid_from,rsh.shipment_header_id) AND nvl(p_shid_to, rsh.shipment_header_id)