APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_SHIPMENT_HEADERS

Line 93: FROM rcv_shipment_headers rsh,

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

Line 118: FROM rcv_shipment_headers rsh,

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

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

155: x_ship_to_organization_id NUMBER;
156: x_sob_id NUMBER := NULL;
157: x_secondary_available_qty NUMBER := 0;
158: x_full_name VARCHAR2(240) := NULL; -- Bug 2392074
159: l_shipment_header_id rcv_shipment_headers.shipment_header_id%TYPE; -- Bugfix 5201151
160: --Bug 8631613
161: l_temp_qty NUMBER;
162: l_pri_temp_qty NUMBER;
163: --Bug 8631613

Line 233: FROM rcv_shipment_headers rsh,

229: */
230: BEGIN
231: SELECT distinct rsh.shipment_header_id
232: INTO l_shipment_header_id
233: FROM rcv_shipment_headers rsh,
234: rcv_shipment_lines rsl
235: WHERE shipment_num = temp_cascaded_table(current_n).shipment_num
236: AND rsh.shipment_header_id = rsl.shipment_header_id
237: AND rsl.to_organization_id = NVL(temp_cascaded_table(current_n).to_organization_id, to_organization_id)

Line 945: FROM rcv_shipment_headers rsh,

941: rsh.conversion_rate_type currency_conversion_type,
942: rsh.conversion_date currency_conversion_date,
943: rsl.to_subinventory,
944: rsl.ship_to_location_id
945: FROM rcv_shipment_headers rsh,
946: rcv_shipment_lines rsl
947: WHERE rsh.shipment_header_id = v_shipment_header_id
948: AND rsh.shipment_header_id = rsl.shipment_header_id
949: AND rsl.shipment_line_id = v_shipment_line_id;