DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on MTL_SYSTEM_ITEMS_KFV

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 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 600: , MTL_SYSTEM_ITEMS_KFV msik

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
602: WHERE d.dummy = 'X'
603: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)
604: AND lpn.lpn_id (+) = p_lpn_id

Line 706: , mtl_system_items_kfv msik

702: , mln.hold_date
703: , mln.expiration_action_code
704: , mln.supplier_lot_number -- invconv fabdi end
705: FROM mtl_parameters mp
706: , mtl_system_items_kfv msik
707: , mtl_lot_numbers mln
708: , po_hazard_classes poh
709: , mtl_material_statuses_vl mmsv
710: WHERE msik.inventory_item_id = p_item_id