DBA Data[Home] [Help]

APPS.AHL_PRD_DISP_MTL_TXN_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 682: mtl_system_items_kfv mtl

678: txn.inventory_item_id, txn.organization_id,
679: txn.serial_number, txn.lot_number,
680: NVL(mtl.comms_nl_trackable_flag,'N') trackable_flag
681: FROM AHL_WORKORDER_MTL_TXNS txn, AHL_WORKORDER_OPERATIONS oper,
682: mtl_system_items_kfv mtl
683: WHERE txn.workorder_mtl_txn_id = p_mtl_txn_id
684: AND txn.workorder_operation_id = oper.workorder_operation_id
685: AND txn.inventory_item_id = mtl.inventory_item_id
686: AND txn.organization_id = mtl.organization_id;

Line 754: mtl_system_items_kfv mtl,

750: disp.quantity-calculate_txned_qty(disp.disposition_id),
751: disp.uom
752: FROM ahl_prd_dispositions_vl disp,
753: ahl_prd_disp_mtl_txns assoc,
754: mtl_system_items_kfv mtl,
755: ahl_item_groups_b grp,
756: fnd_lookup_values flvt1,
757: fnd_lookup_values flvt2,
758: fnd_lookup_values flvt3

Line 848: mtl_system_items_kfv mtl,

844: disp.quantity-calculate_txned_qty(disp.disposition_id),
845: disp.uom
846: FROM ahl_prd_dispositions_vl disp,
847: ahl_prd_disp_mtl_txns assoc,
848: mtl_system_items_kfv mtl,
849: ahl_item_groups_b grp,
850: fnd_lookup_values flvt1,
851: fnd_lookup_values flvt2,
852: fnd_lookup_values flvt3