APPS.INV_DIAG_PI_GEN dependencies on MTL_PHYSICAL_INVENTORIES

Line 49: FROM MTL_PHYSICAL_INVENTORIES

45: l_count NUMBER;
46:
47: CURSOR c_phy_inv (cp_n_org_id IN NUMBER, cp_n_phy_inv_id IN NUMBEr) IS
48: SELECT count(*)
49: FROM MTL_PHYSICAL_INVENTORIES
50: WHERE organization_id = cp_n_org_id
51: AND physical_inventory_id = cp_n_phy_inv_id;
52:
53:

Line 326: ' FROM mtl_physical_inventories_v mpi ' ||

322: ' , mpi.total_adjustment_value ' ||
323: ' , mpi.next_tag_number ' ||
324: ' , mpi.tag_number_increments ' ||
325: ' , mpi.number_of_skus ' ||
326: ' FROM mtl_physical_inventories_v mpi ' ||
327: ' , mfg_lookups ml ' ||
328: ' WHERE mpi.organization_id = ' || l_org_id ||
329: ' AND mpi.physical_inventory_id = ' || l_phy_inv_id ||
330: ' AND mpi.approval_required = ml.lookup_code(+) ' ||