DBA Data[Home] [Help]

APPS.INV_LABEL_PVT10 dependencies on MTL_SYSTEM_ITEMS_KFV

Line 71: FROM MTL_SYSTEM_ITEMS_KFV item,

67: item.attribute9,
68: item.attribute_category,
69: item_poh. hazard_class,
70: item_mir.revision
71: FROM MTL_SYSTEM_ITEMS_KFV item,
72: PO_HAZARD_CLASSES item_poh,
73: MTL_ITEM_REVISIONS item_mir
74: WHERE item.organization_id = p_organization_id
75: AND item.inventory_item_id = p_inventory_item_id

Line 739: mtl_system_items_kfv lpn_msik1,

735: decode(lpn_wlc.serial_summary_entry, 1, 1, lpn_wlc.quantity)) quantity,
736: lpn_wlc.uom_code
737: FROM wms_license_plate_numbers lpn,
738: wms_license_plate_numbers lpn_pLpn,
739: mtl_system_items_kfv lpn_msik1,
740: mtl_system_items_kfv lpn_msik2,
741: mtl_parameters lpn_mp,
742: wms_lpn_contents lpn_wlc
743: WHERE lpn.lpn_id = p_lpn_id

Line 740: mtl_system_items_kfv lpn_msik2,

736: lpn_wlc.uom_code
737: FROM wms_license_plate_numbers lpn,
738: wms_license_plate_numbers lpn_pLpn,
739: mtl_system_items_kfv lpn_msik1,
740: mtl_system_items_kfv lpn_msik2,
741: mtl_parameters lpn_mp,
742: wms_lpn_contents lpn_wlc
743: WHERE lpn.lpn_id = p_lpn_id
744: AND lpn.parent_lpn_id = lpn_pLpn.lpn_id(+)