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.

[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on WMS_PACKAGING_HIST

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

517: WHERE transaction_interface_id = p_transaction_id;
518:
519: -- The above cursor returns all the packages/LPN's in the parent_lpn_id.
520: -- The gross weight and other information is from the next level which is achieved by
521: -- opening the wms_packaging_hist as wph1. wph is the packlevel = 0 while wph1 is the
522: -- pack_level = 1;
523:
524: /*Changing the cursor due to performance related changes. Bug 4237831
525: CURSOR c_mmtt_cart_lpn IS

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

526: SELECT distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
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

Line 533: from wms_packaging_hist

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
536: CONNECT BY PARENT_PACKAGE_ID = PRIOR PACKAGE_ID)
537: AND msik.inventory_item_id (+) = wph.parent_item_id

Line 549: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv

545: SELECT /*+ rowid(WPH) */ distinct(wph.parent_package_id), wph.lpn_id, wph1.content_volume_uom_code, wph1.content_volume,
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

Line 552: from wms_packaging_hist

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
555: CONNECT BY PARENT_PACKAGE_ID = PRIOR PACKAGE_ID)
556: AND msik.inventory_item_id (+) = wph.parent_item_id

Line 650: , WMS_PACKAGING_HIST wph

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
654: , DUAL d

Line 1026: FROM wms_packaging_hist wpc

1022: , milkfv.inventory_location_id locator_id
1023: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
1024: , l_secondary_transaction_qty secondary_quantity -- invconv fabdi
1025: , l_secondary_uom_code secondary_uom -- invconv fabdi
1026: FROM wms_packaging_hist wpc
1027: , mtl_material_transactions_temp mmtt
1028: , mtl_system_items msi
1029: , cst_cost_groups ccg
1030: , mtl_item_locations milkfv

Line 1034: WHERE wpc.rowid in ( select /+ cardinality(1) / id from ((select rowid id from wms_packaging_hist

1030: , mtl_item_locations milkfv
1031: -- Bug 4137707, Do not need to include this where clause,
1032: -- This will be controlled when opening this cursor
1033: -- WHERE cartonization_flag = 1 --Cartonization Flow
1034: WHERE wpc.rowid in ( select /*+ cardinality(1) */ id from ((select rowid id from wms_packaging_hist
1035: where pack_level = 0
1036: AND header_id = l_header_id
1037: AND packaging_mode = l_packaging_mode
1038: AND lpn_id is null

Line 1044: select rowid from wms_packaging_hist

1040: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID
1041:
1042: union all
1043:
1044: select rowid from wms_packaging_hist
1045: where pack_level = 0
1046: AND lpn_id is null
1047: start with parent_package_id = p_package_id
1048: connect by PARENT_PACKAGE_ID = PRIOR PACKAGE_ID) ) t )

Line 1901: FROM WMS_PACKAGING_HIST

1897: -- if no records found, should not try to access wph, so set flag to 0
1898: BEGIN
1899: SELECT DISTINCT header_id, packaging_mode, pack_level
1900: INTO l_header_id, l_packaging_mode, l_max_pack_level
1901: FROM WMS_PACKAGING_HIST
1902: WHERE parent_lpn_id = p_transaction_id;
1903: EXCEPTION
1904: WHEN no_data_found THEN
1905: IF (l_debug = 1) THEN