APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1143: FROM MTL_SYSTEM_ITEMS_B

1139:
1140: -- The following depends on the fact that ahl_schedule_materials records all quantities in the primary_uom_code
1141: -- of the item, which is the case currently as it is a requirement from WIP
1142: SELECT PRIMARY_UOM_CODE INTO l_uom_code
1143: FROM MTL_SYSTEM_ITEMS_B
1144: WHERE INVENTORY_ITEM_ID = p_x_ahl_mtltxn_tbl(i).Inventory_Item_Id
1145: AND ORGANIZATION_ID = p_x_ahl_mtltxn_tbl(i).Organization_Id;
1146:
1147: IF (l_uom_code <> p_x_ahl_mtltxn_tbl(i).uom)

Line 3261: FROM MTL_SYSTEM_ITEMS_B

3257: ret boolean;
3258: -- Query to check if item is trakkable
3259: CURSOR Item_tr_Cur(p_org_Id NUMBER, p_item_Id NUMBER) IS
3260: SELECT 1
3261: FROM MTL_SYSTEM_ITEMS_B
3262: WHERE INVENTORY_ITEM_ID = p_Item_Id
3263: AND ORGANIZATION_ID = p_Org_Id
3264: AND COMMS_NL_TRACKABLE_FLAG = 'Y'
3265: AND ENABLED_FLAG = 'Y'

Line 4168: MTL_SYSTEM_ITEMS_B

4164: SERIAL_NUMBER_CONTROL_CODE,
4165: LOT_CONTROL_CODE,
4166: REVISION_QTY_CONTROL_CODE
4167: FROM
4168: MTL_SYSTEM_ITEMS_B
4169: WHERE
4170: inventory_item_id=c_inv_item_id
4171: AND ORGANIZATION_ID=c_org_id;
4172: