APPS.INV_PHY_INV_LOVS dependencies on MTL_PHYSICAL_INVENTORIES

Line 56: FROM mtl_physical_inventories_v

52: approval_tolerance_neg,
53: approval_tolerance_pos,
54: all_subinventories_flag,
55: dynamic_tag_entry_flag
56: FROM mtl_physical_inventories_v
57: WHERE organization_id = p_organization_id
58: AND snapshot_complete = 1
59: AND adjustments_posted <> 1
60: AND physical_inventory_name LIKE (p_phy_inv)

Line 128: FROM mtl_physical_inventories

124: -- Now see if the serial is within the scope of the physical
125: -- inventory
126: SELECT all_subinventories_flag
127: INTO l_all_sub_flag
128: FROM mtl_physical_inventories
129: WHERE physical_inventory_id = p_physical_inventory_id
130: AND organization_id = p_organization_id;
131: IF (l_debug = 1) THEN
132: print_debug('All subinventories flag: ' || l_all_sub_flag);

Line 683: FROM mtl_physical_inventories

679: l_tag_qty_at_standard_uom NUMBER;
680: l_outermost_lpn_id NUMBER;
681: CURSOR tag_number_cursor IS
682: SELECT next_tag_number
683: FROM mtl_physical_inventories
684: WHERE physical_inventory_id = p_physical_inventory_id
685: AND organization_id = p_organization_id;
686: l_return_status VARCHAR2(300);
687: l_msg_count NUMBER;

Line 757: UPDATE MTL_PHYSICAL_INVENTORIES

753: l_from_number := l_from_number + 1;
754: l_padded_length := l_length - length(l_from_number);
755: l_next_tag_number := RPAD(NVL(l_prefix, '0'), l_padded_length, '0') ||
756: l_from_number;
757: UPDATE MTL_PHYSICAL_INVENTORIES
758: SET next_tag_number = l_next_tag_number
759: WHERE physical_inventory_id = p_physical_inventory_id
760: AND organization_id = p_organization_id;
761: IF (l_debug = 1) THEN