APPS.INV_PHY_INV_LOVS dependencies on MTL_PHYSICAL_INVENTORIES

Line 58: FROM mtl_physical_inventories_v

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

Line 130: FROM mtl_physical_inventories

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

Line 793: FROM mtl_physical_inventories

789: l_outermost_lpn_id NUMBER;
790: l_lot_expiration_date Date; /* Bug8199582 */
791: CURSOR tag_number_cursor IS
792: SELECT next_tag_number
793: FROM mtl_physical_inventories
794: WHERE physical_inventory_id = p_physical_inventory_id
795: AND organization_id = p_organization_id;
796: l_return_status VARCHAR2(300);
797: l_msg_count NUMBER;

Line 867: UPDATE MTL_PHYSICAL_INVENTORIES

863: l_from_number := l_from_number + 1;
864: l_padded_length := l_length - length(l_from_number);
865: l_next_tag_number := RPAD(NVL(l_prefix, '0'), l_padded_length, '0') ||
866: l_from_number;
867: UPDATE MTL_PHYSICAL_INVENTORIES
868: SET next_tag_number = l_next_tag_number
869: WHERE physical_inventory_id = p_physical_inventory_id
870: AND organization_id = p_organization_id;
871: IF (l_debug = 1) THEN

Line 2447: FROM mtl_physical_inventories

2443: Mydebug(' l_transaction_header_id ..'||l_transaction_header_id);
2444:
2445:
2446: SELECT description INTO l_transaction_reference
2447: FROM mtl_physical_inventories
2448: WHERE physical_inventory_id = p_physical_inv_id;
2449:
2450: FOR i IN c_physical_xfer(p_organization_id, p_physical_inv_id)
2451: LOOP