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.INV_RCV_STD_RCPT_APIS dependencies on RCV_SHIPMENT_LINES

Line 1273: FROM rcv_shipment_lines

1269: IF nvl(v_pre_receive, 'N') = 'Y' THEN
1270:
1271: SELECT LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST
1272: INTO v_lcm_ship_line_id, v_unit_landed_cost
1273: FROM rcv_shipment_lines
1274: WHERE shipment_line_id = l_shipment_line_id;
1275:
1276: UPDATE rcv_transactions_interface
1277: SET lcm_shipment_line_id = v_lcm_ship_line_id,

Line 2648: , rcv_shipment_lines rsl

2644: , NULL secondary_uom --OPM Convergence
2645: , NULL secondary_uom_code --OPM Convergence
2646: , NULL secondary_quantity --OPM Convergence temp
2647: FROM rcv_shipment_headers rsh
2648: , rcv_shipment_lines rsl
2649: , po_requisition_headers porh
2650: , po_requisition_lines porl
2651: , mtl_system_items msi
2652: , mtl_system_items msi1

Line 2760: FROM rcv_shipment_lines rsl,

2756: /* We'll get shipment_header_id for req at front end
2757: IF p_shipment_header_id IS NULL THEN
2758: SELECT DISTINCT rsl.shipment_header_id
2759: INTO l_shipment_header_id
2760: FROM rcv_shipment_lines rsl,
2761: po_requisition_lines prl
2762: WHERE
2763: prl.requisition_header_id = p_req_header_id
2764: AND prl.requisition_line_id = rsl.requisition_line_id;

Line 3918: FROM rcv_shipment_lines rsl

3914: , NULL task_id
3915: , NULL secondary_uom --OPM Convergence
3916: , NULL secondary_uom_code --OPM Convergence
3917: , NULL secondary_quantity --OPM Convergence
3918: FROM rcv_shipment_lines rsl
3919: , rcv_shipment_headers rsh
3920: , po_headers poh
3921: , po_line_locations poll
3922: , po_lines pol

Line 4091: , rcv_shipment_lines rsl

4087: , NULL secondary_uom --OPM Convergence
4088: , NULL secondary_uom_code --OPM Convergence
4089: , NULL secondary_quantity --OPM Convergence temp
4090: FROM rcv_shipment_headers rsh
4091: , rcv_shipment_lines rsl
4092: , po_requisition_headers porh
4093: , po_requisition_lines porl
4094: , mtl_system_items msi
4095: , mtl_system_items msi1

Line 6197: , rcv_shipment_lines rsl

6193: , mtln.secondary_transaction_quantity --OPM Convergence
6194: FROM mtl_material_transactions mmt
6195: , mtl_transaction_lot_numbers mtln
6196: , rcv_transactions rt
6197: , rcv_shipment_lines rsl
6198: , mtl_system_items msi
6199: WHERE rt.interface_transaction_id = p_txn_source_id
6200: AND mmt.rcv_transaction_id = rt.transaction_id
6201: AND mmt.transaction_id = mtln.transaction_id

Line 6424: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;

6420: l_po_line_location_id NUMBER := NULL;
6421: l_po_distribution_id NUMBER := NULL;
6422: l_is_asn VARCHAR2(1);
6423: l_is_req VARCHAR2(1) := 'N'; -- Bug 5460505
6424: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;
6425: BEGIN
6426: IF (l_debug = 1) THEN
6427: print_debug('create_move_order: 1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6428: END IF;

Line 6452: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

6448: BEGIN
6449: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
6450: decode(rsh.asn_type,'ASN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
6451: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
6452: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
6453: WHERE rsl.shipment_line_id = p_shipment_line_id
6454: AND rsl.shipment_header_id = rsh.shipment_header_id;
6455: EXCEPTION
6456: WHEN OTHERS THEN

Line 6525: FROM rcv_shipment_lines

6521:
6522: BEGIN
6523: SELECT po_line_location_id, po_distribution_id, source_document_code
6524: INTO l_po_line_location_id, l_po_distribution_id, l_source_document_code
6525: FROM rcv_shipment_lines
6526: WHERE shipment_line_id = p_shipment_line_id;
6527: EXCEPTION
6528: WHEN OTHERS THEN
6529: IF (l_debug = 1) THEN

Line 6610: FROM rcv_shipment_lines rsl

6606: ELSE
6607: BEGIN
6608: SELECT cost_group_id
6609: INTO l_from_cost_group_id
6610: FROM rcv_shipment_lines rsl
6611: WHERE shipment_line_id = p_shipment_line_id
6612: AND exists (
6613: SELECT 1
6614: FROM cst_cost_group_accounts

Line 6742: FROM rcv_shipment_lines rsl

6738: ELSE
6739: BEGIN
6740: SELECT cost_group_id
6741: INTO l_from_cost_group_id
6742: FROM rcv_shipment_lines rsl
6743: WHERE shipment_line_id = p_shipment_line_id
6744: AND exists (
6745: SELECT 1
6746: FROM cst_cost_group_accounts

Line 8586: FROM rcv_shipment_lines rsl

8582: -- fix for bug 2403033
8583: BEGIN
8584: SELECT 1
8585: INTO l_lot_serial_flag
8586: FROM rcv_shipment_lines rsl
8587: , rcv_shipment_headers rsh
8588: , mtl_system_items msi1
8589: , mtl_system_items msi2
8590: WHERE rsh.shipment_num = p_shipment_number

Line 8679: FROM rcv_shipment_lines rsl

8675: -- fix for bug 2403033
8676: BEGIN
8677: SELECT 1
8678: INTO l_lot_serial_flag
8679: FROM rcv_shipment_lines rsl
8680: , rcv_shipment_headers rsh
8681: , mtl_system_items msi1
8682: , mtl_system_items msi2
8683: WHERE rsh.shipment_header_id = p_shipment_header_id

Line 8901: , rcv_shipment_lines rsl

8897: SELECT 2
8898: INTO l_lpn_flag
8899: FROM po_requisition_headers prh
8900: , po_requisition_lines prl
8901: , rcv_shipment_lines rsl
8902: , mtl_system_items msi1
8903: , mtl_system_items msi2
8904: WHERE prh.segment1 = p_req_num
8905: AND prl.requisition_header_id = prh.requisition_header_id

Line 9156: rcv_shipment_lines rsl

9152: NVL(SUM(rlsu.primary_quantity),0)
9153: INTO l_rlsu_quantity,
9154: l_rlsu_primary_quantity
9155: FROM rcv_lots_supply rlsu,
9156: rcv_shipment_lines rsl
9157: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9158: AND rsl.item_id = p_inventory_item_id
9159: AND rsl.to_organization_id = p_rcv_org_id
9160: AND rsl.shipment_header_id = p_shipment_header_id

Line 9247: rcv_shipment_lines rsl

9243: BEGIN
9244: SELECT NVL(SUM(rlsu.primary_quantity),0)
9245: INTO l_rlsu_primary_quantity
9246: FROM rcv_lots_supply rlsu,
9247: rcv_shipment_lines rsl
9248: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9249: AND rsl.item_id = p_inventory_item_id
9250: AND rsl.to_organization_id = p_rcv_org_id
9251: AND rsl.shipment_header_id = p_shipment_header_id

Line 9363: rcv_shipment_lines rsl

9359: BEGIN
9360: SELECT NVL(SUM(rlsu.primary_quantity),0)
9361: INTO l_rlsu_primary_quantity
9362: FROM rcv_lots_supply rlsu,
9363: rcv_shipment_lines rsl
9364: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9365: AND rsl.item_id = p_inventory_item_id
9366: AND rsl.to_organization_id = p_rcv_org_id
9367: AND rsl.shipment_header_id = p_shipment_header_id