eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_INT_ORG_TRANSFER dependencies on RCV_SHIPMENT_LINES

Line 94: rcv_shipment_lines rsl

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

Line 119: rcv_shipment_lines rsl

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

Line 234: rcv_shipment_lines rsl

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

Line 946: rcv_shipment_lines rsl

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

Line 1247: rcv_shipment_lines rsl,

1243: rt.deliver_to_location_id,
1244: rt.subinventory,
1245: rt.transfer_lpn_id
1246: FROM rcv_transactions rt,
1247: rcv_shipment_lines rsl,
1248: rcv_supply rsup
1249: WHERE rt.transaction_id = v_parent_trx_id
1250: AND rt.transaction_id = rsup.rcv_transaction_id
1251: AND rsup.supply_type_code = 'RECEIVING'

Line 1577: rcv_shipment_lines rsl

1573: rt.quantity qty,
1574: 0 interface_available_qty
1575: FROM rcv_supply rsup,
1576: rcv_transactions rt,
1577: rcv_shipment_lines rsl
1578: WHERE rt.transaction_id = v_parent_trx_id
1579: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)
1580: AND rsup.supply_type_code = 'RECEIVING'
1581: AND rsl.shipment_line_id = rsup.shipment_line_id

Line 2370: rcv_shipment_lines rsl

2366: rt.destination_type_code,
2367: rsl.ussgl_transaction_code,
2368: rt.oe_order_line_id
2369: FROM rcv_transactions rt,
2370: rcv_shipment_lines rsl
2371: WHERE rt.transaction_id = v_parent_trx_id
2372: AND rt.shipment_line_id = rsl.shipment_line_id
2373: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)
2374: AND rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'RETURN TO CUSTOMER')

Line 2852: rcv_shipment_lines rsl

2848: INTO l_transaction_uom,
2849: l_item_id,
2850: l_primary_uom
2851: FROM rcv_transactions rt,
2852: rcv_shipment_lines rsl
2853: WHERE rsl.shipment_line_id = rt.shipment_line_id
2854: AND rt.transaction_id = int_org_cor_rec.rcv_transaction_id;
2855:
2856: SELECT NVL(SUM(interface_transaction_qty),0)

Line 3142: rcv_shipment_lines rsl

3138: rt.lpn_id,
3139: rt.transfer_lpn_id,
3140: rt.transaction_type
3141: FROM rcv_transactions rt,
3142: rcv_shipment_lines rsl
3143: WHERE rt.transaction_id = v_parent_trx_id
3144: AND rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT')
3145: AND rt.shipment_line_id = rsl.shipment_line_id
3146: ORDER BY rt.transaction_id;

Line 3177: p_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE

3173: WHERE interface_transaction_id = v_parent_inter_trx_id;
3174:
3175: --bug 3704623
3176: CURSOR int_org_cor_rsl(
3177: p_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE
3178: ) IS
3179: SELECT to_organization_id,
3180: from_organization_id
3181: FROM rcv_shipment_lines

Line 3181: FROM rcv_shipment_lines

3177: p_shipment_line_id rcv_shipment_lines.shipment_line_id%TYPE
3178: ) IS
3179: SELECT to_organization_id,
3180: from_organization_id
3181: FROM rcv_shipment_lines
3182: WHERE shipment_line_id = p_shipment_line_id;
3183:
3184: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;
3185: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;

Line 3184: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;

3180: from_organization_id
3181: FROM rcv_shipment_lines
3182: WHERE shipment_line_id = p_shipment_line_id;
3183:
3184: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;
3185: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;
3186: default_int_org_cor_rt_info int_org_cor_rt%ROWTYPE;
3187: x_progress VARCHAR2(3);
3188: temp_index NUMBER;

Line 3185: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;

3181: FROM rcv_shipment_lines
3182: WHERE shipment_line_id = p_shipment_line_id;
3183:
3184: x_from_organization_id rcv_shipment_lines.from_organization_id%TYPE;
3185: x_to_organization_id rcv_shipment_lines.to_organization_id%TYPE;
3186: default_int_org_cor_rt_info int_org_cor_rt%ROWTYPE;
3187: x_progress VARCHAR2(3);
3188: temp_index NUMBER;
3189: lpn_error NUMBER := 0;

Line 3510: from rcv_shipment_lines

3506: */
3507: If (x_cascaded_table(n).transaction_type = 'RECEIVE') then
3508: select nvl(max(shipment_header_id),0)
3509: into x_header_id
3510: from rcv_shipment_lines
3511: where shipment_header_id =
3512: x_header_record.header_record.receipt_header_id
3513: and shipment_line_id = x_cascaded_table(n).shipment_line_id;
3514: