APPS.RCV_RECEIPT_CONFIRMATION dependencies on RCV_SHIPMENT_LINES

Line 35: rcv_shipment_lines rsl,

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
39: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)

Line 61: rcv_shipment_lines rsl,

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
65: AND rt.transaction_date BETWEEN nvl(l_trx_date_from,rt.transaction_date) AND nvl(l_trx_date_to, rt.transaction_date)

Line 338: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl

334: WHERE rt.parent_transaction_id = rt3.transaction_id
335: AND rt3.transaction_type = 'RETURN TO RECEIVING')
336: )
337: )
338: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl
339: WHERE rsl.shipment_line_id = rt.shipment_line_id
340: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);
341:
342: ELSE

Line 416: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl

412: WHERE rt.parent_transaction_id = rt3.transaction_id
413: AND rt3.transaction_type = 'RETURN TO RECEIVING')
414: )
415: )
416: AND EXISTS (SELECT '1' FROM rcv_shipment_lines rsl
417: WHERE rsl.shipment_line_id = rt.shipment_line_id
418: AND wms_deploy.get_client_code(rsl.item_id) = p_client_code);
419:
420: ELSE