APPS.INV_PHY_INV_LOVS dependencies on MTL_PHYSICAL_INVENTORY_TAGS

Line 109: FROM mtl_physical_inventory_tags

105: -- First get the serial count number to see if the serial has
106: -- already been found for this physical inventory
107: SELECT COUNT(*)
108: INTO x_number
109: FROM mtl_physical_inventory_tags
110: WHERE physical_inventory_id = p_physical_inventory_id
111: AND organization_id = p_organization_id
112: AND serial_num = p_serial_number
113: AND inventory_item_id = p_inventory_item_id

Line 192: FROM mtl_physical_inventory_tags

188: IS
189: l_current_serial VARCHAR2(30);
190: CURSOR tag_entry IS
191: SELECT *
192: FROM mtl_physical_inventory_tags
193: WHERE physical_inventory_id = p_physical_inventory_id
194: AND organization_id = p_organization_id
195: AND subinventory = p_subinventory
196: AND NVL(locator_id, -99999) = NVL(p_locator_id, -99999)

Line 212: FROM mtl_physical_inventory_tags

208: AND organization_id = p_organization_id
209: AND approval_status IS NULL);
210: CURSOR discrepant_serial_cursor IS
211: SELECT *
212: FROM mtl_physical_inventory_tags
213: WHERE physical_inventory_id = p_physical_inventory_id
214: AND organization_id = p_organization_id
215: AND NVL(parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
216: AND inventory_item_id = p_inventory_item_id

Line 228: tag_record MTL_PHYSICAL_INVENTORY_TAGS%ROWTYPE;

224: FROM mtl_physical_adjustments
225: WHERE physical_inventory_id = p_physical_inventory_id
226: AND organization_id = p_organization_id
227: AND approval_status IS NULL);
228: tag_record MTL_PHYSICAL_INVENTORY_TAGS%ROWTYPE;
229: l_prefix VARCHAR2(30);
230: l_quantity NUMBER;
231: l_from_number NUMBER;
232: l_to_number NUMBER;

Line 707: SELECT mtl_physical_inventory_tags_s.nextval

703: IF (l_debug = 1) THEN
704: print_debug('***insert_row***');
705: END IF;
706: -- Get the next tag ID for this new record
707: SELECT mtl_physical_inventory_tags_s.nextval
708: INTO l_tag_id
709: FROM dual;
710: IF (l_debug = 1) THEN
711: print_debug('Dynamic tag ID: ' || l_tag_id);

Line 722: FROM mtl_physical_inventory_tags

718: -- No value set for next_tag_number so manually
719: -- generate the next sequence value
720: SELECT MAX(tag_number)
721: INTO l_tag_number
722: FROM mtl_physical_inventory_tags
723: WHERE physical_inventory_id = p_physical_inventory_id
724: AND organization_id = p_organization_id;
725: -- Now parse the tag number and increment the numerical part
726: l_temp_bool := MTL_Serial_Check.inv_serial_info

Line 842: INSERT INTO MTL_PHYSICAL_INVENTORY_TAGS

838: -- Insert the new record
839: IF (l_debug = 1) THEN
840: print_debug('Inserting the new record here');
841: END IF;
842: INSERT INTO MTL_PHYSICAL_INVENTORY_TAGS
843: (tag_id,
844: physical_inventory_id,
845: organization_id,
846: last_update_date,

Line 1024: UPDATE MTL_PHYSICAL_INVENTORY_TAGS

1020: -- Update the record
1021: IF (l_debug = 1) THEN
1022: print_debug('Updating the physical inventory tag record for tag ID: ' || p_tag_id);
1023: END IF;
1024: UPDATE MTL_PHYSICAL_INVENTORY_TAGS
1025: SET
1026: last_update_date = SYSDATE,
1027: last_updated_by = p_user_id,
1028: last_update_login = p_user_id,

Line 1084: FROM mtl_physical_inventory_tags

1080: print_debug('***update_adjustment***');
1081: END IF;
1082: SELECT NVL(SUM(tag_quantity_at_standard_uom),0)
1083: INTO l_adj_count_quantity
1084: FROM mtl_physical_inventory_tags
1085: WHERE adjustment_id = p_adjustment_id
1086: AND organization_id = p_organization_id
1087: AND physical_inventory_id = p_physical_inventory_id
1088: AND void_flag = 2;

Line 1606: FROM mtl_physical_inventory_tags

1602: SET group_mark_id = -1
1603: WHERE inventory_item_id = p_item_id
1604: AND serial_number in
1605: (SELECT DISTINCT serial_num
1606: FROM mtl_physical_inventory_tags
1607: WHERE organization_id = p_organization_id
1608: AND physical_inventory_id = p_physical_inventory_id
1609: AND inventory_item_id = p_item_id
1610: AND serial_num is not null