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 1307: FROM rcv_shipment_lines

1303: IF nvl(v_pre_receive, 'N') = 'Y' THEN
1304:
1305: SELECT LCM_SHIPMENT_LINE_ID, UNIT_LANDED_COST
1306: INTO v_lcm_ship_line_id, v_unit_landed_cost
1307: FROM rcv_shipment_lines
1308: WHERE shipment_line_id = l_shipment_line_id;
1309:
1310: UPDATE rcv_transactions_interface
1311: SET lcm_shipment_line_id = v_lcm_ship_line_id,

Line 1331: update rcv_shipment_lines set ITEM_REVISION = v_item_revision where shipment_line_id = l_shipment_line_id;

1327:
1328: -- bug 13598673 added the following update stmnt
1329: v_item_revision := l_rcv_transaction_rec.item_revision;
1330: IF v_item_revision IS NOT NULL AND l_rcv_transaction_rec.source_type_code='ASN' THEN
1331: update rcv_shipment_lines set ITEM_REVISION = v_item_revision where shipment_line_id = l_shipment_line_id;
1332: END IF;
1333: -- End of bug 13598673
1334:
1335:

Line 2704: , rcv_shipment_lines rsl

2700: , NULL secondary_uom --OPM Convergence
2701: , NULL secondary_uom_code --OPM Convergence
2702: , NULL secondary_quantity --OPM Convergence temp
2703: FROM rcv_shipment_headers rsh
2704: , rcv_shipment_lines rsl
2705: , po_requisition_headers porh
2706: , po_requisition_lines porl
2707: , mtl_system_items msi
2708: , mtl_system_items msi1

Line 2818: FROM rcv_shipment_lines rsl,

2814: /* We'll get shipment_header_id for req at front end
2815: IF p_shipment_header_id IS NULL THEN
2816: SELECT DISTINCT rsl.shipment_header_id
2817: INTO l_shipment_header_id
2818: FROM rcv_shipment_lines rsl,
2819: po_requisition_lines prl
2820: WHERE
2821: prl.requisition_header_id = p_req_header_id
2822: AND prl.requisition_line_id = rsl.requisition_line_id;

Line 4099: FROM rcv_shipment_lines rsl

4095: , NULL task_id
4096: , NULL secondary_uom --OPM Convergence
4097: , NULL secondary_uom_code --OPM Convergence
4098: , NULL secondary_quantity --OPM Convergence
4099: FROM rcv_shipment_lines rsl
4100: , rcv_shipment_headers rsh
4101: , po_headers poh
4102: , po_line_locations poll
4103: , po_lines pol

Line 4272: , rcv_shipment_lines rsl

4268: , NULL secondary_uom --OPM Convergence
4269: , NULL secondary_uom_code --OPM Convergence
4270: , NULL secondary_quantity --OPM Convergence temp
4271: FROM rcv_shipment_headers rsh
4272: , rcv_shipment_lines rsl
4273: , po_requisition_headers porh
4274: , po_requisition_lines porl
4275: , mtl_system_items msi
4276: , mtl_system_items msi1

Line 6548: , rcv_shipment_lines rsl

6544: , mtln.secondary_transaction_quantity --OPM Convergence
6545: FROM mtl_material_transactions mmt
6546: , mtl_transaction_lot_numbers mtln
6547: , rcv_transactions rt
6548: , rcv_shipment_lines rsl
6549: , mtl_system_items msi
6550: WHERE rt.interface_transaction_id = p_txn_source_id
6551: AND mmt.rcv_transaction_id = rt.transaction_id
6552: AND mmt.transaction_id = mtln.transaction_id

Line 6775: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;

6771: l_po_line_location_id NUMBER := NULL;
6772: l_po_distribution_id NUMBER := NULL;
6773: l_is_asn VARCHAR2(1);
6774: l_is_req VARCHAR2(1) := 'N'; -- Bug 5460505
6775: l_source_document_code rcv_shipment_lines.source_document_code%TYPE;
6776: BEGIN
6777: IF (l_debug = 1) THEN
6778: print_debug('create_move_order: 1 ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
6779: END IF;

Line 6803: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh

6799: BEGIN
6800: SELECT rsl.po_line_location_id,rsl.po_distribution_id,
6801: decode(rsh.asn_type,'ASN','Y','N'),Decode(rsh.receipt_source_code,'INTERNAL ORDER','Y','N')
6802: INTO l_po_line_location_id,l_po_distribution_id,l_is_asn,l_is_req
6803: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh
6804: WHERE rsl.shipment_line_id = p_shipment_line_id
6805: AND rsl.shipment_header_id = rsh.shipment_header_id;
6806: EXCEPTION
6807: WHEN OTHERS THEN

Line 6880: FROM rcv_shipment_lines

6876:
6877: BEGIN
6878: SELECT po_line_location_id, po_distribution_id, source_document_code
6879: INTO l_po_line_location_id, l_po_distribution_id, l_source_document_code
6880: FROM rcv_shipment_lines
6881: WHERE shipment_line_id = p_shipment_line_id;
6882: EXCEPTION
6883: WHEN OTHERS THEN
6884: IF (l_debug = 1) THEN

Line 6965: FROM rcv_shipment_lines rsl

6961: /*ELSE--START commented for bug 16711363
6962: BEGIN
6963: SELECT cost_group_id
6964: INTO l_from_cost_group_id
6965: FROM rcv_shipment_lines rsl
6966: WHERE shipment_line_id = p_shipment_line_id
6967: AND exists (
6968: SELECT 1
6969: FROM cst_cost_group_accounts

Line 7097: FROM rcv_shipment_lines rsl

7093: /*ELSE --START commented for bug 16711363
7094: BEGIN
7095: SELECT cost_group_id
7096: INTO l_from_cost_group_id
7097: FROM rcv_shipment_lines rsl
7098: WHERE shipment_line_id = p_shipment_line_id
7099: AND exists (
7100: SELECT 1
7101: FROM cst_cost_group_accounts

Line 8982: FROM rcv_shipment_lines rsl

8978: -- fix for bug 2403033
8979: BEGIN
8980: SELECT 1
8981: INTO l_lot_serial_flag
8982: FROM rcv_shipment_lines rsl
8983: , rcv_shipment_headers rsh
8984: , mtl_system_items msi1
8985: , mtl_system_items msi2
8986: WHERE rsh.shipment_num = p_shipment_number

Line 9075: FROM rcv_shipment_lines rsl

9071: -- fix for bug 2403033
9072: BEGIN
9073: SELECT 1
9074: INTO l_lot_serial_flag
9075: FROM rcv_shipment_lines rsl
9076: , rcv_shipment_headers rsh
9077: , mtl_system_items msi1
9078: , mtl_system_items msi2
9079: WHERE rsh.shipment_header_id = p_shipment_header_id

Line 9297: , rcv_shipment_lines rsl

9293: SELECT 2
9294: INTO l_lpn_flag
9295: FROM po_requisition_headers prh
9296: , po_requisition_lines prl
9297: , rcv_shipment_lines rsl
9298: , mtl_system_items msi1
9299: , mtl_system_items msi2
9300: WHERE prh.segment1 = p_req_num
9301: AND prl.requisition_header_id = prh.requisition_header_id

Line 9552: rcv_shipment_lines rsl

9548: NVL(SUM(rlsu.primary_quantity),0)
9549: INTO l_rlsu_quantity,
9550: l_rlsu_primary_quantity
9551: FROM rcv_lots_supply rlsu,
9552: rcv_shipment_lines rsl
9553: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9554: AND rsl.item_id = p_inventory_item_id
9555: AND rsl.to_organization_id = p_rcv_org_id
9556: AND rsl.shipment_header_id = p_shipment_header_id

Line 9643: rcv_shipment_lines rsl

9639: BEGIN
9640: SELECT NVL(SUM(rlsu.primary_quantity),0)
9641: INTO l_rlsu_primary_quantity
9642: FROM rcv_lots_supply rlsu,
9643: rcv_shipment_lines rsl
9644: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9645: AND rsl.item_id = p_inventory_item_id
9646: AND rsl.to_organization_id = p_rcv_org_id
9647: AND rsl.shipment_header_id = p_shipment_header_id

Line 9791: rcv_shipment_lines rsl

9787: BEGIN
9788: SELECT NVL(SUM(rlsu.primary_quantity),0)
9789: INTO l_rlsu_primary_quantity
9790: FROM rcv_lots_supply rlsu,
9791: rcv_shipment_lines rsl
9792: WHERE rlsu.shipment_line_id = rsl.shipment_line_id
9793: AND rsl.item_id = p_inventory_item_id
9794: AND rsl.to_organization_id = p_rcv_org_id
9795: AND rsl.shipment_header_id = p_shipment_header_id