DBA Data[Home] [Help]

APPS.EAM_MATERIAL_ALLOCQTY_PKG dependencies on MTL_SYSTEM_ITEMS

Line 118: FROM mtl_system_items_b_kfv mtlbkfv

114: SELECT
115: mtlbkfv.lot_control_code,
116: mtlbkfv.serial_number_control_code,
117: mtlbkfv.revision_qty_control_code
118: FROM mtl_system_items_b_kfv mtlbkfv
119: WHERE mtlbkfv.organization_id = p_organization_id
120: AND mtlbkfv.inventory_item_id = p_inventory_item_id;
121:
122: l_is_revision_control BOOLEAN;

Line 210: MTL_SYSTEM_ITEMS MSI

206: SELECT NVL(SUM(QUANTITY),0)
207: into l_qoh
208: FROM MTL_SECONDARY_INVENTORIES MSS,
209: MTL_ITEM_QUANTITIES_VIEW MOQ,
210: MTL_SYSTEM_ITEMS MSI
211: WHERE MOQ.ORGANIZATION_ID = p_organization_id
212: AND MSI.ORGANIZATION_ID = p_organization_id
213: AND MSS.ORGANIZATION_ID = p_organization_id
214: AND MOQ.INVENTORY_ITEM_ID = p_inventory_item_id