APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_SHIPMENT_LINES

Line 93: rcv_shipment_lines rsl

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'))
97: WHERE rsh.shipment_header_id = v_shipment_header_id -- Bugfix 5201151

Line 116: rcv_shipment_lines rsl

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'))
120: WHERE rsh.shipment_header_id = v_shipment_header_id -- Bugfix 5201151

Line 226: rcv_shipment_lines rsl

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)
230: AND rsl.from_organization_id = NVL(temp_cascaded_table(current_n).from_organization_id, from_organization_id)

Line 913: rcv_shipment_lines rsl

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;
917:

Line 1204: rcv_shipment_lines rsl,

1200: rt.deliver_to_location_id,
1201: rt.subinventory,
1202: rt.transfer_lpn_id
1203: FROM rcv_transactions rt,
1204: rcv_shipment_lines rsl,
1205: rcv_supply rsup
1206: WHERE rt.transaction_id = v_parent_trx_id
1207: AND rt.transaction_id = rsup.rcv_transaction_id
1208: AND rsup.supply_type_code = 'RECEIVING'

Line 1534: rcv_shipment_lines rsl

1530: rt.quantity qty,
1531: 0 interface_available_qty
1532: FROM rcv_supply rsup,
1533: rcv_transactions rt,
1534: rcv_shipment_lines rsl
1535: WHERE rt.transaction_id = v_parent_trx_id
1536: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
1537: AND rsup.supply_type_code = 'RECEIVING'
1538: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 2295: rcv_shipment_lines rsl

2291: rt.destination_type_code,
2292: rsl.ussgl_transaction_code,
2293: rt.oe_order_line_id
2294: FROM rcv_transactions rt,
2295: rcv_shipment_lines rsl
2296: WHERE rt.transaction_id = v_parent_trx_id
2297: AND rt.shipment_line_id = rsl.shipment_line_id
2298: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)
2299: AND rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'RETURN TO CUSTOMER')

Line 2777: rcv_shipment_lines rsl

2773: INTO l_transaction_uom,
2774: l_item_id,
2775: l_primary_uom
2776: FROM rcv_transactions rt,
2777: rcv_shipment_lines rsl
2778: WHERE rsl.shipment_line_id = rt.shipment_line_id
2779: AND rt.transaction_id = int_org_cor_rec.rcv_transaction_id;
2780:
2781: SELECT NVL(SUM(interface_transaction_qty),0)

Line 3067: rcv_shipment_lines rsl

3063: rt.lpn_id,
3064: rt.transfer_lpn_id,
3065: rt.transaction_type
3066: FROM rcv_transactions rt,
3067: rcv_shipment_lines rsl
3068: WHERE rt.transaction_id = v_parent_trx_id
3069: AND rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT')
3070: AND rt.shipment_line_id = rsl.shipment_line_id
3071: ORDER BY rt.transaction_id;

Line 3102: p_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE

3098: WHERE interface_transaction_id = v_parent_inter_trx_id;
3099:
3100: --bug 3704623
3101: CURSOR int_org_cor_rsl(
3102: p_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE
3103: ) IS
3104: SELECT to_organization_id,
3105: from_organization_id
3106: FROM rcv_shipment_lines

Line 3106: FROM rcv_shipment_lines

3102: p_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE
3103: ) IS
3104: SELECT to_organization_id,
3105: from_organization_id
3106: FROM rcv_shipment_lines
3107: WHERE shipment_line_id = p_shipment_line_id;
3108:
3109: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;
3110: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;

Line 3109: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;

3105: from_organization_id
3106: FROM rcv_shipment_lines
3107: WHERE shipment_line_id = p_shipment_line_id;
3108:
3109: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;
3110: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;
3111: default_int_org_cor_rt_info int_org_cor_rt%ROWTYPE;
3112: x_progress VARCHAR2(3);
3113: temp_index NUMBER;

Line 3110: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;

3106: FROM rcv_shipment_lines
3107: WHERE shipment_line_id = p_shipment_line_id;
3108:
3109: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;
3110: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;
3111: default_int_org_cor_rt_info int_org_cor_rt%ROWTYPE;
3112: x_progress VARCHAR2(3);
3113: temp_index NUMBER;
3114: lpn_error NUMBER := 0;

Line 3435: from rcv_shipment_lines

3431: */
3432: If (x_cascaded_table(n).transaction_type = 'RECEIVE') then
3433: select nvl(max(shipment_header_id),0)
3434: into x_header_id
3435: from rcv_shipment_lines
3436: where shipment_header_id =
3437: x_header_record.header_record.receipt_header_id
3438: and shipment_line_id = x_cascaded_table(n).shipment_line_id;
3439: