APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1268: FROM MTL_SYSTEM_ITEMS_B

1264:
1265: -- The following depends on the fact that ahl_schedule_materials records all quantities in the primary_uom_code
1266: -- of the item, which is the case currently as it is a requirement from WIP
1267: SELECT PRIMARY_UOM_CODE INTO l_uom_code
1268: FROM MTL_SYSTEM_ITEMS_B
1269: WHERE INVENTORY_ITEM_ID = p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id
1270: AND ORGANIZATION_ID = p_x_ahl_mtltxn_tbl(i).Organization_Id;
1271:
1272: IF (l_uom_code <> p_x_ahl_mtltxn_tbl(i).uom)

Line 3828: FROM MTL_SYSTEM_ITEMS_B

3824: ret boolean;
3825: -- Query to check if item is trakkable
3826: CURSOR Item_tr_Cur(p_org_Id NUMBER, p_item_Id NUMBER) IS
3827: SELECT 1
3828: FROM MTL_SYSTEM_ITEMS_B
3829: WHERE INVENTORY_ITEM_ID = p_Item_Id
3830: AND ORGANIZATION_ID = p_Org_Id
3831: AND COMMS_NL_TRACKABLE_FLAG = 'Y'
3832: AND ENABLED_FLAG = 'Y'

Line 4884: MTL_SYSTEM_ITEMS_B

4880: SERIAL_NUMBER_CONTROL_CODE,
4881: LOT_CONTROL_CODE,
4882: REVISION_QTY_CONTROL_CODE
4883: FROM
4884: MTL_SYSTEM_ITEMS_B
4885: WHERE
4886: inventory_item_id=c_inv_item_id
4887: AND ORGANIZATION_ID=c_org_id;
4888: