APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 694: mtl_system_items_kfv mtl

690: txn.inventory_item_id, txn.organization_id,
691: txn.serial_number, txn.lot_number,
692: NVL(mtl.comms_nl_trackable_flag,'N') trackable_flag
693: FROM AHL_WORKORDER_MTL_TXNS txn, AHL_WORKORDER_OPERATIONS oper,
694: mtl_system_items_kfv mtl
695: WHERE txn.workorder_mtl_txn_id = p_mtl_txn_id
696: AND txn.workorder_operation_id = oper.workorder_operation_id
697: AND txn.inventory_item_id = mtl.inventory_item_id
698: AND txn.organization_id = mtl.organization_id;

Line 766: mtl_system_items_kfv mtl,

762: disp.quantity-calculate_txned_qty(disp.disposition_id),
763: disp.uom
764: FROM ahl_prd_dispositions_vl disp,
765: ahl_prd_disp_mtl_txns assoc,
766: mtl_system_items_kfv mtl,
767: ahl_item_groups_b grp,
768: fnd_lookup_values flvt1,
769: fnd_lookup_values flvt2,
770: fnd_lookup_values flvt3

Line 860: mtl_system_items_kfv mtl,

856: disp.quantity-calculate_txned_qty(disp.disposition_id),
857: disp.uom
858: FROM ahl_prd_dispositions_vl disp,
859: ahl_prd_disp_mtl_txns assoc,
860: mtl_system_items_kfv mtl,
861: ahl_item_groups_b grp,
862: fnd_lookup_values flvt1,
863: fnd_lookup_values flvt2,
864: fnd_lookup_values flvt3