APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_SHIPMENT_HEADERS

Line 92: FROM rcv_shipment_headers rsh,

88: rsl.destination_type_code destination_type_code,
89: rsl.destination_context destination_context,
90: rsl.unit_of_measure unit_of_measure,
91: rsl.primary_unit_of_measure primary_unit_of_measure
92: FROM rcv_shipment_headers rsh,
93: rcv_shipment_lines rsl
94: -- Following 2 lines are commented out for Bugfix 5201151
95: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
96: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))

Line 115: FROM rcv_shipment_headers rsh,

111: v_ship_to_org_id NUMBER,
112: v_ship_from_org_id NUMBER
113: ) IS
114: SELECT COUNT(*) AS line_count
115: FROM rcv_shipment_headers rsh,
116: rcv_shipment_lines rsl
117: -- Following 2 lines are commented out for Bugfix 5201151
118: -- WHERE rsh.shipment_header_id = NVL(v_shipment_header_id, rsh.shipment_header_id)
119: -- AND NVL(rsh.shipment_num, '0') = NVL(v_shipment_num, NVL(rsh.shipment_num, '0'))

Line 155: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE; -- Bugfix 5201151

151: x_ship_to_organization_id NUMBER;
152: x_sob_id NUMBER := NULL;
153: x_secondary_available_qty NUMBER := 0;
154: x_full_name VARCHAR2(240) := NULL; -- Bug 2392074
155: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE; -- Bugfix 5201151
156: BEGIN
157: --check line quanity > 0
158: x_progress := '097';
159:

Line 225: FROM rcv_shipment_headers rsh,

221: */
222: BEGIN
223: SELECT distinct rsh.shipment_header_id
224: INTO l_shipment_header_id
225: FROM rcv_shipment_headers rsh,
226: rcv_shipment_lines rsl
227: WHERE shipment_num = temp_cascaded_table(current_n).shipment_num
228: AND rsh.shipment_header_id = rsl.shipment_header_id
229: AND rsl.to_organization_id = NVL(temp_cascaded_table(current_n).to_organization_id, to_organization_id)

Line 912: FROM rcv_shipment_headers rsh,

908: rsh.conversion_rate_type currency_conversion_type,
909: rsh.conversion_date currency_conversion_date,
910: rsl.to_subinventory,
911: rsl.ship_to_location_id
912: FROM rcv_shipment_headers rsh,
913: rcv_shipment_lines rsl
914: WHERE rsh.shipment_header_id = v_shipment_header_id
915: AND rsh.shipment_header_id = rsl.shipment_header_id
916: AND rsl.shipment_line_id = v_shipment_line_id;