eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_PHY_INV_LOVS dependencies on MTL_PHYSICAL_INVENTORY_TAGS

Line 111: FROM mtl_physical_inventory_tags

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

Line 194: FROM mtl_physical_inventory_tags

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

Line 215: FROM mtl_physical_inventory_tags

211: AND approval_status IS NULL) OR adjustment_id IS NULL); --bug#9772069
212:
213: CURSOR discrepant_serial_cursor IS
214: SELECT *
215: FROM mtl_physical_inventory_tags
216: WHERE physical_inventory_id = p_physical_inventory_id
217: AND organization_id = p_organization_id
218: AND NVL(parent_lpn_id, -99999) = NVL(p_parent_lpn_id, -99999)
219: AND inventory_item_id = p_inventory_item_id

Line 234: FROM mtl_physical_inventory_tags

230: AND approval_status IS NULL) OR adjustment_id IS NULL); --bug#9772069
231:
232: CURSOR tag_entry_wo_serial IS --bug#9772069
233: SELECT *
234: FROM mtl_physical_inventory_tags
235: WHERE physical_inventory_id = p_physical_inventory_id
236: AND organization_id = p_organization_id
237: AND subinventory = p_subinventory
238: AND NVL(locator_id, -99999) = NVL(p_locator_id, -99999)

Line 254: tag_record MTL_PHYSICAL_INVENTORY_TAGS%ROWTYPE;

250: WHERE physical_inventory_id = p_physical_inventory_id
251: AND organization_id = p_organization_id
252: AND approval_status IS NULL) OR adjustment_id IS NULL);
253:
254: tag_record MTL_PHYSICAL_INVENTORY_TAGS%ROWTYPE;
255: l_prefix VARCHAR2(30);
256: l_quantity NUMBER;
257: l_from_number NUMBER;
258: l_to_number NUMBER;

Line 817: SELECT mtl_physical_inventory_tags_s.nextval

813: IF (l_debug = 1) THEN
814: print_debug('***insert_row***');
815: END IF;
816: -- Get the next tag ID for this new record
817: SELECT mtl_physical_inventory_tags_s.nextval
818: INTO l_tag_id
819: FROM dual;
820: IF (l_debug = 1) THEN
821: print_debug('Dynamic tag ID: ' || l_tag_id);

Line 832: FROM mtl_physical_inventory_tags

828: -- No value set for next_tag_number so manually
829: -- generate the next sequence value
830: SELECT MAX(tag_number)
831: INTO l_tag_number
832: FROM mtl_physical_inventory_tags
833: WHERE physical_inventory_id = p_physical_inventory_id
834: AND organization_id = p_organization_id;
835: -- Now parse the tag number and increment the numerical part
836: l_temp_bool := MTL_Serial_Check.inv_serial_info

Line 986: INSERT INTO MTL_PHYSICAL_INVENTORY_TAGS

982: -- Insert the new record
983: IF (l_debug = 1) THEN
984: print_debug('Inserting the new record here');
985: END IF;
986: INSERT INTO MTL_PHYSICAL_INVENTORY_TAGS
987: (tag_id,
988: physical_inventory_id,
989: organization_id,
990: last_update_date,

Line 1186: UPDATE MTL_PHYSICAL_INVENTORY_TAGS

1182: -- Update the record
1183: IF (l_debug = 1) THEN
1184: print_debug('Updating the physical inventory tag record for tag ID: ' || p_tag_id);
1185: END IF;
1186: UPDATE MTL_PHYSICAL_INVENTORY_TAGS
1187: SET
1188: last_update_date = SYSDATE,
1189: last_updated_by = p_user_id,
1190: last_update_login = p_user_id,

Line 1253: FROM mtl_physical_inventory_tags

1249: SELECT NVL(SUM(tag_quantity_at_standard_uom),0),
1250: NVL(SUM(tag_secondary_quantity),0)
1251: INTO l_adj_count_quantity,
1252: l_adj2_count_quantity
1253: FROM mtl_physical_inventory_tags
1254: WHERE adjustment_id = p_adjustment_id
1255: AND organization_id = p_organization_id
1256: AND physical_inventory_id = p_physical_inventory_id
1257: AND void_flag = 2;

Line 1836: FROM mtl_physical_inventory_tags

1832: SET group_mark_id = -1
1833: WHERE inventory_item_id = p_item_id
1834: AND serial_number in
1835: (SELECT DISTINCT serial_num
1836: FROM mtl_physical_inventory_tags
1837: WHERE organization_id = p_organization_id
1838: AND physical_inventory_id = p_physical_inventory_id
1839: AND inventory_item_id = p_item_id
1840: AND serial_num is not null

Line 2090: FROM mtl_physical_inventory_tags

2086: AND NVL(revision,'@@@@') = NVL(p_revision,'@@@@')
2087: AND NVL(lot_number,'@@@@') = NVL(p_lot_number,'@@@@')
2088: AND NVL(serial_number,'@@@@') = NVL(p_serial_number,'@@@@')
2089: AND adjustment_id IN (SELECT adjustment_id
2090: FROM mtl_physical_inventory_tags
2091: WHERE organization_id = p_organization_id
2092: AND physical_inventory_id = p_physical_inventory_id
2093: AND inventory_item_id = p_inventory_item_id
2094: AND parent_lpn_id = p_parent_lpn_id

Line 2160: DELETE FROM mtl_physical_inventory_tags

2156: WHERE adjustment_id = p_adjustment_id;
2157: END IF;
2158: /* For bug 15926209, end */
2159:
2160: DELETE FROM mtl_physical_inventory_tags
2161: WHERE adjustment_id = l_adjustment_id;
2162:
2163: IF (l_debug = 1) THEN
2164: print_debug('PI_ER.. Count of deleted recs for mtl_physical_inventory_tags >>> '||SQL%ROWCOUNT||' for LPN Id, Adj Id '||p_parent_lpn_id ||' , '||l_adjustment_id);

Line 2164: print_debug('PI_ER.. Count of deleted recs for mtl_physical_inventory_tags >>> '||SQL%ROWCOUNT||' for LPN Id, Adj Id '||p_parent_lpn_id ||' , '||l_adjustment_id);

2160: DELETE FROM mtl_physical_inventory_tags
2161: WHERE adjustment_id = l_adjustment_id;
2162:
2163: IF (l_debug = 1) THEN
2164: print_debug('PI_ER.. Count of deleted recs for mtl_physical_inventory_tags >>> '||SQL%ROWCOUNT||' for LPN Id, Adj Id '||p_parent_lpn_id ||' , '||l_adjustment_id);
2165: END IF;
2166:
2167: DELETE FROM mtl_physical_adjustments
2168: WHERE adjustment_id = l_adjustment_id;

Line 2259: AND mpa.adjustment_id IN (SELECT adjustment_id FROM mtl_physical_inventory_tags

2255: AND ( mpa.subinventory_name <> wlp.subinventory_code OR mpa.locator_id <> wlp.locator_id )
2256: AND Nvl(mpa.count_quantity, 0) <> 0
2257: AND mpa.approval_status = 1
2258: AND mpa.parent_lpn_id IS NOT NULL
2259: AND mpa.adjustment_id IN (SELECT adjustment_id FROM mtl_physical_inventory_tags
2260: WHERE organization_id = p_org_id
2261: AND physical_inventory_id = p_phy_inv_id AND void_flag = 2)
2262:
2263: ) wms,

Line 2288: AND adjustment_id IN (SELECT adjustment_id FROM mtl_physical_inventory_tags

2284: AND system_quantity = 0
2285: AND nvl(count_quantity,0) <> 0
2286: AND approval_status = 1
2287: AND parent_lpn_id IS NOT NULL
2288: AND adjustment_id IN (SELECT adjustment_id FROM mtl_physical_inventory_tags
2289: WHERE organization_id = p_org_id
2290: AND physical_inventory_id = p_phy_inv_id
2291: AND void_flag=2)
2292: ) mpa_xfr

Line 2566: UPDATE mtl_physical_inventory_tags

2562:
2563: /* --bug 14778466, commented below code since the count qty remains same, SO no need to update MPIT table .
2564: BEGIN
2565: mydebug(' Updating MPIT with adjustment_id : '||i.xfr_adjustment_id );
2566: UPDATE mtl_physical_inventory_tags
2567: set locator_id = nvl(i.to_locator, l_prev_loctor)
2568: , subinventory = nvl(i.xfr_subinventory_name,l_prev_subinv)
2569: , tag_quantity = i.count_quantity --bug 14778466
2570: , tag_quantity_at_standard_uom = inv_convert.inv_um_convert

Line 2589: UPDATE mtl_physical_inventory_tags

2585: AND physical_inventory_ID = p_physical_inv_id
2586: AND organization_id = p_organization_id;
2587: Exception
2588: when others then
2589: UPDATE mtl_physical_inventory_tags
2590: set locator_id = nvl(i.to_locator, l_prev_loctor)
2591: , subinventory = nvl(i.xfr_subinventory_name,l_prev_subinv)
2592: , tag_quantity = i.count_quantity
2593: , tag_secondary_quantity = i.secondary_count_qty --bug 14778466

Line 2720: FROM mtl_physical_inventory_tags

2716: AND NVL(revision,'@@@@') = NVL(i.revision,'@@@@')
2717: AND NVL(lot_number,'@@@@') = NVL(i.lot_number,'@@@@')
2718: AND NVL(serial_number,'@@@@') = NVL(i.serial_number,'@@@@')
2719: AND adjustment_id IN (SELECT adjustment_id
2720: FROM mtl_physical_inventory_tags
2721: WHERE organization_id = p_organization_id
2722: AND physical_inventory_id = p_physical_inv_id
2723: AND inventory_item_id = i.inventory_item_id
2724: AND parent_lpn_id = i.parent_lpn_id

Line 2743: DELETE FROM mtl_physical_inventory_tags

2739: mydebug(' Got the Adj id to delete recs from MPA, MPIT : '||l_adj_id);
2740:
2741: IF l_adj_id IS NOT NULL THEN
2742:
2743: DELETE FROM mtl_physical_inventory_tags
2744: WHERE adjustment_id = l_adj_id
2745: and physical_inventory_id = p_physical_inv_id
2746: and organization_id = p_organization_id;
2747: