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_LABEL_PVT1 dependencies on WMS_LPN_CONTENTS

Line 368: , wms_lpn_contents wlc

364: , RTI.WIP_OPERATION_SEQ_NUM
365: , rti.DEPARTMENT_CODE
366: , rti.BOM_RESOURCE_ID
367: FROM rcv_transactions_interface rti
368: , wms_lpn_contents wlc
369: , po_lines_trx_v pol -- CLM project, bug 9403291
370: , po_headers_trx_v pha -- CLM project, bug 9403291
371: , rcv_shipment_headers rsh
372: , po_line_locations_trx_v pll -- CLM project, bug 9403291

Line 450: , wms_lpn_contents wlc

446: , RTI.WIP_OPERATION_SEQ_NUM
447: , rti.DEPARTMENT_CODE
448: , rti.BOM_RESOURCE_ID
449: FROM rcv_transactions_interface rti
450: , wms_lpn_contents wlc
451: , po_lines_trx_v pol -- CLM project, bug 9403291
452: , po_headers_trx_v pha -- CLM projet, bug 9403291
453: , rcv_shipment_headers rsh
454: , po_line_locations_trx_v pll -- CLM project, bug 9403291

Line 1328: -- material info from WMS_LPN_CONTENTS

1324:
1325:
1326: -- Bug Fix for bug 2251686
1327: -- If content lpn_id in MMTT is populated, we have to get the
1328: -- material info from WMS_LPN_CONTENTS
1329: -- New Union to this table has been added
1330: CURSOR mmtt_material_cur IS
1331: SELECT mmtt.inventory_item_id inventory_item_id
1332: , mmtt.organization_id organization_id

Line 1368: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1364: , mmtt.locator_id
1365: , mmtt.transfer_to_location
1366: , wlc.secondary_uom_code -- added for invconv
1367: , wlc.secondary_quantity -- added for invconv
1368: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1369: WHERE mmtt.transaction_temp_id = p_transaction_id
1370: AND mmtt.content_lpn_id IS NOT NULL
1371: AND mmtt.content_lpn_id = wlc.parent_lpn_id;
1372:

Line 1464: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1460: , mmtt.locator_id
1461: , mmtt.transfer_to_location
1462: , wlc.secondary_quantity -- added for invconv
1463: , wlc.secondary_uom_code -- added for invconv
1464: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1465: WHERE mmtt.transaction_temp_id = p_transaction_id
1466: AND mmtt.content_lpn_id = wlc.parent_lpn_id
1467: UNION ALL
1468: -- This part of the cursor is for 2 cases. Items unpacked from an LPN and packed into another LPN AND

Line 1485: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1481: , mmtt.locator_id
1482: , mmtt.transfer_to_location
1483: , wlc.secondary_quantity -- added for invconv
1484: , wlc.secondary_uom_code -- added for invconv
1485: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1486: WHERE mmtt.transaction_temp_id = p_transaction_id
1487: AND mmtt.transfer_lpn_id = wlc.parent_lpn_id
1488: UNION ALL
1489: -- This part of the cursor is for all cases except loose items being packed into an existing/new LPN.

Line 1505: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt

1501: , mmtt.locator_id
1502: , mmtt.transfer_to_location
1503: , wlc.secondary_quantity -- added for invconv
1504: , wlc.secondary_uom_code -- added for invconv
1505: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1506: WHERE mmtt.transaction_temp_id = p_transaction_id
1507: AND mmtt.lpn_id = wlc.parent_lpn_id;
1508:
1509: -- Packaging/Cartonization Cursors

Line 1517: FROM wms_lpn_contents wlc, WMS_LICENSE_PLATE_NUMBERS wlpn

1513: , wlc.inventory_item_id
1514: , wlc.revision
1515: , wlc.lot_number
1516: , SUM(wlc.quantity)
1517: FROM wms_lpn_contents wlc, WMS_LICENSE_PLATE_NUMBERS wlpn
1518: WHERE wlpn.OUTERMOST_LPN_ID = p_transaction_id
1519: and wlc.parent_lpn_id = wlpn.lpn_id
1520: GROUP BY wlc.organization_id
1521: , wlc.inventory_item_id

Line 2045: FROM wms_lpn_contents wlc ,

2041: wlc.secondary_uom_code ,
2042: wlc.secondary_quantity ,
2043: wipe.wip_entity_name ,
2044: mmtt.trx_source_line_id
2045: FROM wms_lpn_contents wlc ,
2046: mtl_material_transactions_temp mmtt,
2047: wip_entities wipe
2048: WHERE mmtt.transaction_temp_id = p_transaction_id
2049: AND mmtt.transaction_source_id = wipe.wip_entity_id

Line 2388: -- from the wms_lpn_contents and the rest information from the

2384: AND (l_is_wms_org = TRUE)
2385: ) THEN
2386: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2387: -- Receipt and Inspection, WMS org, obtaining the lot information
2388: -- from the wms_lpn_contents and the rest information from the
2389: -- rti record
2390: OPEN rti_material_lpn_cur;
2391: FETCH rti_material_lpn_cur INTO l_inventory_item_id
2392: , l_organization_id

Line 2444: -- from the wms_lpn_contents and the rest information from the rti record

2440: ELSIF ((p_label_type_info.business_flow_code IN (2))
2441: AND (l_is_wms_org = TRUE)
2442: ) THEN
2443: -- Receipt and Inspection, WMS org, obtaining the lot information
2444: -- from the wms_lpn_contents and the rest information from the rti record
2445: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2446: OPEN rti_material_lpn_inspec_cur;
2447: FETCH rti_material_lpn_inspec_cur INTO l_inventory_item_id
2448: , l_organization_id