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_PACKAGING_HIST

Line 470: -- opening the wms_packaging_hist as wph1. wph is the packlevel = 0 while wph1 is the

466: WHERE transaction_interface_id = p_transaction_id;
467:
468: -- The above cursor returns all the packages/LPN's in the parent_lpn_id.
469: -- The gross weight and other information is from the next level which is achieved by
470: -- opening the wms_packaging_hist as wph1. wph is the packlevel = 0 while wph1 is the
471: -- pack_level = 1;
472:
473: /*Changing the cursor due to performance related changes. Bug 4237831
474: CURSOR c_mmtt_cart_lpn IS

Line 479: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,

475: SELECT distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
476: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
477: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
478: msik.concatenated_segments container_item, lpn.license_plate_number, wph2.pack_level
479: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,
480: WMS_LICENSE_PLATE_NUMBERS lpn
481: WHERE wph.rowid in (select rowid
482: from wms_packaging_hist
483: where pack_level = 0

Line 482: from wms_packaging_hist

478: msik.concatenated_segments container_item, lpn.license_plate_number, wph2.pack_level
479: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,
480: WMS_LICENSE_PLATE_NUMBERS lpn
481: WHERE wph.rowid in (select rowid
482: from wms_packaging_hist
483: where pack_level = 0
484: START WITH parent_lpn_id = p_transaction_id
485: CONNECT BY PARENT_PACKAGE_ID = PRIOR PACKAGE_ID)
486: AND msik.inventory_item_id (+) = wph.parent_item_id

Line 497: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv

493: SELECT distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
494: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
495: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
496: msik.concatenated_segments container_item,lpn.license_plate_number
497: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv
498: msik, WMS_LICENSE_PLATE_NUMBERS lpn
499: WHERE wph.rowid in (select rowid
500: from wms_packaging_hist
501: where pack_level = 0

Line 500: from wms_packaging_hist

496: msik.concatenated_segments container_item,lpn.license_plate_number
497: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv
498: msik, WMS_LICENSE_PLATE_NUMBERS lpn
499: WHERE wph.rowid in (select rowid
500: from wms_packaging_hist
501: where pack_level = 0
502: START WITH parent_lpn_id = p_transaction_id
503: CONNECT BY PARENT_PACKAGE_ID = PRIOR PACKAGE_ID)
504: AND msik.inventory_item_id (+) = wph.parent_item_id

Line 597: , WMS_PACKAGING_HIST wph

593: , lpn.attribute15 lpn_attribute15
594: , nvl(wph.parent_package_id, l_package_id) parent_package --l_parent_package_id) parent_package
595: , nvl(wph.pack_level, l_pack_level) pack_level
596: FROM WMS_LICENSE_PLATE_NUMBERS lpn
597: , WMS_PACKAGING_HIST wph
598: , WMS_LICENSE_PLATE_NUMBERS plpn
599: , WMS_LICENSE_PLATE_NUMBERS olpn
600: , MTL_SYSTEM_ITEMS_KFV msik
601: , DUAL d

Line 852: FROM wms_packaging_hist wpc

848: , milkfv.inventory_location_id locator_id
849: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
850: , l_secondary_transaction_qty secondary_quantity -- invconv fabdi
851: , l_secondary_uom_code secondary_uom -- invconv fabdi
852: FROM wms_packaging_hist wpc
853: , mtl_material_transactions_temp mmtt
854: , mtl_system_items msi
855: , cst_cost_groups ccg
856: , mtl_item_locations milkfv

Line 860: WHERE wpc.rowid in (select rowid from wms_packaging_hist

856: , mtl_item_locations milkfv
857: -- Bug 4137707, Do not need to include this where clause,
858: -- This will be controlled when opening this cursor
859: -- WHERE cartonization_flag = 1 --Cartonization Flow
860: WHERE wpc.rowid in (select rowid from wms_packaging_hist
861: where pack_level = 0
862: AND header_id = l_header_id
863: AND packaging_mode = l_packaging_mode
864: AND lpn_id is null

Line 870: select rowid from wms_packaging_hist

866: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID
867:
868: union all
869:
870: select rowid from wms_packaging_hist
871: where pack_level = 0
872: AND lpn_id is null
873: start with parent_package_id = p_package_id
874: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID)

Line 1529: FROM WMS_PACKAGING_HIST

1525: -- if no records found, should not try to access wph, so set flag to 0
1526: BEGIN
1527: SELECT DISTINCT header_id, packaging_mode, pack_level
1528: INTO l_header_id, l_packaging_mode, l_max_pack_level
1529: FROM WMS_PACKAGING_HIST
1530: WHERE parent_lpn_id = p_transaction_id;
1531: EXCEPTION
1532: WHEN no_data_found THEN
1533: IF (l_debug = 1) THEN