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_PVT4 dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 260: from wms_license_plate_numbers lpn,

256: , rt.quantity
257: , rt.project_id -- bug 8430171
258: , rt.task_id -- bug 8430171
259: , rt.shipment_line_id --- 15918971
260: from wms_license_plate_numbers lpn,
261: rcv_transactions rt
262: where lpn.lpn_id = rt.lpn_id
263: and lpn.parent_lpn_id <> rt.lpn_id
264: and rt.group_id = p_transaction_id

Line 288: from wms_license_plate_numbers lpn, rcv_transactions rt

284: , rt.quantity
285: , rt.project_id -- bug 8430171
286: , rt.task_id -- bug 8430171
287: , rt.shipment_line_id --- 15918971
288: from wms_license_plate_numbers lpn, rcv_transactions rt
289: where lpn.lpn_id = rt.lpn_id
290: and lpn.outermost_lpn_id <> lpn.lpn_id
291: and lpn.outermost_lpn_id <> lpn.parent_lpn_id
292: and rt.group_id = p_transaction_id

Line 341: from wms_license_plate_numbers lpn, rcv_transactions rt

337: , rt.quantity
338: , rt.project_id -- bug 8430171
339: , rt.task_id -- bug 8430171
340: , rt.shipment_line_id --- 15918971
341: from wms_license_plate_numbers lpn, rcv_transactions rt
342: where lpn.lpn_id = rt.transfer_lpn_id
343: and rt.transfer_lpn_id <> rt.lpn_id
344: and lpn.parent_lpn_id <> lpn.lpn_id
345: and lpn.parent_lpn_id is not null -- parentLPN could be null for single-level LPN

Line 369: from wms_license_plate_numbers lpn, rcv_transactions rt

365: , rt.quantity
366: , rt.project_id -- bug 8430171
367: , rt.task_id -- bug 8430171
368: , rt.shipment_line_id --- 15918971
369: from wms_license_plate_numbers lpn, rcv_transactions rt
370: where lpn.lpn_id = rt.transfer_lpn_id
371: and rt.transfer_lpn_id <> rt.lpn_id
372: and lpn.outermost_lpn_id <> lpn.lpn_id
373: and lpn.outermost_lpn_id <> lpn.parent_lpn_id

Line 397: , wms_license_plate_numbers wlpn

393: -- , hr_locations_all hrl2
394: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
395: , po_vendor_sites_all pvs
396: , per_people_f ppf
397: , wms_license_plate_numbers wlpn
398: WHERE pha.po_header_id(+) = all_lpn.po_header_id
399: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
400: AND rsh.shipment_header_id = rsl.shipment_header_id
401: /* Bug 5241400, Add where clause for rsl and appl_lpn location_id */

Line 531: WMS_LICENSE_PLATE_NUMBERS lpn

527: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
528: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
529: msik.concatenated_segments container_item, lpn.license_plate_number, wph2.pack_level
530: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,
531: WMS_LICENSE_PLATE_NUMBERS lpn
532: WHERE wph.rowid in (select rowid
533: from wms_packaging_hist
534: where pack_level = 0
535: START WITH parent_lpn_id = p_transaction_id

Line 550: msik, WMS_LICENSE_PLATE_NUMBERS lpn

546: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
547: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
548: msik.concatenated_segments container_item,lpn.license_plate_number
549: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv
550: msik, WMS_LICENSE_PLATE_NUMBERS lpn
551: WHERE wph.rowid in (select /*+ cardinality(1) */ rowid
552: from wms_packaging_hist
553: where pack_level = 0
554: START WITH parent_lpn_id = p_transaction_id

Line 587: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn

583: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
584: */
585: CURSOR c_wdd_lpn IS
586: SELECT wdd.lpn_id, wlpn.organization_id, wlpn.subinventory_code, wlpn.locator_id-- Added locator for Conf Label ER
587: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn
588: WHERE wdd.delivery_detail_id = p_transaction_id
589: AND wdd.lpn_id = wlpn.lpn_id;
590:
591:

Line 614: FROM wms_license_plate_numbers

610: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
611:
612: CURSOR c_child_lpns(p_lpn_id NUMBER) IS
613: SELECT lpn_id
614: FROM wms_license_plate_numbers
615: WHERE parent_lpn_id = p_lpn_id;
616:
617: CURSOR c_lpn_attributes (p_org_id NUMBER, p_lpn_id NUMBER)IS
618: SELECT lpn.LICENSE_PLATE_NUMBER lpn

Line 649: FROM WMS_LICENSE_PLATE_NUMBERS lpn

645: , lpn.attribute14 lpn_attribute14
646: , lpn.attribute15 lpn_attribute15
647: , nvl(wph.parent_package_id, l_package_id) parent_package --l_parent_package_id) parent_package
648: , nvl(wph.pack_level, l_pack_level) pack_level
649: FROM WMS_LICENSE_PLATE_NUMBERS lpn
650: , WMS_PACKAGING_HIST wph
651: , WMS_LICENSE_PLATE_NUMBERS plpn
652: , WMS_LICENSE_PLATE_NUMBERS olpn
653: , MTL_SYSTEM_ITEMS_KFV msik

Line 651: , WMS_LICENSE_PLATE_NUMBERS plpn

647: , nvl(wph.parent_package_id, l_package_id) parent_package --l_parent_package_id) parent_package
648: , nvl(wph.pack_level, l_pack_level) pack_level
649: FROM WMS_LICENSE_PLATE_NUMBERS lpn
650: , WMS_PACKAGING_HIST wph
651: , WMS_LICENSE_PLATE_NUMBERS plpn
652: , WMS_LICENSE_PLATE_NUMBERS olpn
653: , MTL_SYSTEM_ITEMS_KFV msik
654: , DUAL d
655: WHERE d.dummy = 'X'

Line 652: , WMS_LICENSE_PLATE_NUMBERS olpn

648: , nvl(wph.pack_level, l_pack_level) pack_level
649: FROM WMS_LICENSE_PLATE_NUMBERS lpn
650: , WMS_PACKAGING_HIST wph
651: , WMS_LICENSE_PLATE_NUMBERS plpn
652: , WMS_LICENSE_PLATE_NUMBERS olpn
653: , MTL_SYSTEM_ITEMS_KFV msik
654: , DUAL d
655: WHERE d.dummy = 'X'
656: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)

Line 909: , wms_license_plate_numbers plpn

905: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
906: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
907: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
908: FROM wms_lpn_contents wlc
909: , wms_license_plate_numbers plpn
910: , cst_cost_groups ccg
911: , mtl_item_locations milkfv
912: ,(SELECT distinct LPN_ID
913: FROM WMS_LICENSE_PLATE_NUMBERS PLPN

Line 913: FROM WMS_LICENSE_PLATE_NUMBERS PLPN

909: , wms_license_plate_numbers plpn
910: , cst_cost_groups ccg
911: , mtl_item_locations milkfv
912: ,(SELECT distinct LPN_ID
913: FROM WMS_LICENSE_PLATE_NUMBERS PLPN
914: WHERE 1 = 1 START WITH LPN_ID = p_lpn_id CONNECT BY PARENT_LPN_ID = PRIOR LPN_ID ) lid -- Added for bug# 14493747
915: -- Bug 4137707, Do not need to include this where clause,
916: -- This will be controlled when opening this cursor
917: --WHERE cartonization_flag = 0 -- non Cartonization Flow

Line 920: /*wlc.parent_lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers plpn

916: -- This will be controlled when opening this cursor
917: --WHERE cartonization_flag = 0 -- non Cartonization Flow
918: WHERE WLC.PARENT_LPN_ID = lid.LPN_ID -- Added for bug# 14493747
919: --wlc.parent_lpn_id = p_lpn_id /* Modified for the bug # 4771610*/
920: /*wlc.parent_lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers plpn
921: WHERE 1 = 1
922: start with lpn_id = p_lpn_id
923: connect by parent_lpn_id = prior lpn_id) Commented for the bug # 14493747 */
924: AND plpn.lpn_id (+) = wlc.parent_lpn_id

Line 966: FROM wms_license_plate_numbers plpn

962: , milkfv.inventory_location_id locator_id
963: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
964: , sum(nvl(l_secondary_transaction_qty,mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv fabdi
965: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
966: FROM wms_license_plate_numbers plpn
967: , cst_cost_groups ccg
968: , mtl_item_locations milkfv
969: , mtl_material_transactions_temp mmtt
970: -- Bug 4137707, Do not need to include this where clause,

Line 1120: FROM wms_license_plate_numbers lpn,

1116: rsl.truck_num ,
1117: rsl.COUNTRY_OF_ORIGIN_CODE ,
1118: rsl.comments ,
1119: rsl.vendor_item_num
1120: FROM wms_license_plate_numbers lpn,
1121: rcv_shipment_headers rsh,
1122: rcv_shipment_lines rsl
1123: WHERE lpn.source_name = rsh.shipment_num
1124: AND lpn.lpn_context = 7

Line 1149: FROM wms_license_plate_numbers lpn,

1145: rsl.truck_num ,
1146: rsl.COUNTRY_OF_ORIGIN_CODE ,
1147: rsl.comments ,
1148: rsl.vendor_item_num
1149: FROM wms_license_plate_numbers lpn,
1150: rcv_shipment_headers rsh,
1151: rcv_shipment_lines rsl
1152: WHERE lpn.source_name = rsh.shipment_num
1153: AND lpn.lpn_context = 7

Line 1180: FROM wms_license_plate_numbers lpn,

1176: rsl.truck_num ,
1177: rsl.COUNTRY_OF_ORIGIN_CODE ,
1178: rsl.comments ,
1179: rsl.vendor_item_num
1180: FROM wms_license_plate_numbers lpn,
1181: rcv_shipment_headers rsh,
1182: rcv_shipment_lines rsl
1183: WHERE lpn.source_name = rsh.shipment_num
1184: AND lpn.lpn_context = 7

Line 1306: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,

1302: , milkfv.inventory_location_id locator_id
1303: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1304: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1305: , mcce.count_uom_current secondary_uom
1306: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1307: mtl_cycle_count_entries mcce
1308: WHERE cartonization_flag = 0 -- non Cartonization Flow
1309: AND plpn.lpn_id(+) = p_lpn_id
1310: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)

Line 1547: FROM wms_license_plate_numbers

1543: SELECT lpn_id
1544: , license_plate_number
1545: , parent_lpn_id
1546: , outermost_lpn_id
1547: FROM wms_license_plate_numbers
1548: START WITH lpn_id = p_parent_lpn_id
1549: CONNECT BY lpn_id = PRIOR parent_lpn_id;
1550:
1551: CURSOR nested_child_lpn_cursor (p_lpn_id NUMBER) IS

Line 1556: FROM wms_license_plate_numbers

1552: SELECT lpn_id
1553: , license_plate_number
1554: , parent_lpn_id
1555: , outermost_lpn_id
1556: FROM wms_license_plate_numbers
1557: START WITH parent_lpn_id = p_lpn_id
1558: CONNECT BY parent_lpn_id = PRIOR lpn_id;
1559: --END Conf Label ER
1560:

Line 2848: from wms_license_plate_numbers

2844: trace('checkin on hand status');
2845: END IF;
2846: BEGIN
2847: select lpn_context into l_lpn_context_id
2848: from wms_license_plate_numbers
2849: where lpn_id = l_lpn_id;
2850: EXCEPTION
2851: WHEN No_Data_Found THEN
2852: l_lpn_context_id := -99 ;