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_CONSIGNED_VALIDATIONS dependencies on MTL_CONSIGNED_QTY_TEMP

Line 101: --SELECT COUNT(*)INTO l_table_count FROM mtl_consigned_qty_temp

97: CLOSE get_item_info;
98: -- invConv changes end
99:
100: -- query the temp table and first check if any rows exists
101: --SELECT COUNT(*)INTO l_table_count FROM mtl_consigned_qty_temp
102: -- WHERE inventory_item_id = p_inventory_item_id
103: --AND organization_id = p_organization_id;
104: -- Use Exists to check existance
105: l_table_count := 0;

Line 108: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp

104: -- Use Exists to check existance
105: l_table_count := 0;
106: BEGIN
107: SELECT 1 INTO l_table_count FROM dual
108: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp
109: WHERE inventory_item_id = p_inventory_item_id
110: AND organization_id = p_organization_id);
111: EXCEPTION
112: WHEN others THEN

Line 118: inv_log_util.trace('No record found in mtl_consigned_qty_temp, return 0','CONSIGNED_VALIDATIONS',9);

114: END;
115:
116: IF (l_table_count = 0) THEN
117: IF (l_debug = 1) THEN
118: inv_log_util.trace('No record found in mtl_consigned_qty_temp, return 0','CONSIGNED_VALIDATIONS',9);
119: END IF;
120: x_qoh := 0;
121:
122: -- invConv changes begin

Line 187: FROM mtl_consigned_qty_temp

183: -- invConv change : added secondary quantity
184: SELECT Nvl(sum(primary_quantity),0)
185: , Nvl(sum(secondary_quantity),0)
186: INTO l_qoh, l_sqoh
187: FROM mtl_consigned_qty_temp
188: WHERE organization_id = p_organization_id
189: AND inventory_item_id = p_inventory_item_id
190: AND
191: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

Line 203: FROM mtl_consigned_qty_temp

199: -- invConv change : added secondary quantity
200: SELECT Nvl(sum(primary_quantity),0)
201: , Nvl(sum(secondary_quantity),0)
202: INTO l_qoh, l_sqoh
203: FROM mtl_consigned_qty_temp
204: WHERE organization_id = p_organization_id
205: AND inventory_item_id = p_inventory_item_id
206: AND
207: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

Line 220: FROM mtl_consigned_qty_temp

216: -- invConv change : added secondary quantity
217: SELECT Nvl(sum(primary_quantity),0)
218: , Nvl(sum(secondary_quantity),0)
219: INTO l_qoh, l_sqoh
220: FROM mtl_consigned_qty_temp
221: WHERE organization_id = p_organization_id
222: AND inventory_item_id = p_inventory_item_id
223: AND Nvl(planning_organization_id, -999) =
224: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))

Line 238: FROM mtl_consigned_qty_temp

234: -- invConv change : added secondary quantity
235: SELECT Nvl(sum(primary_quantity),0)
236: , Nvl(sum(secondary_quantity),0)
237: INTO l_qoh, l_sqoh
238: FROM mtl_consigned_qty_temp
239: WHERE organization_id = p_organization_id
240: AND inventory_item_id = p_inventory_item_id
241: AND Nvl(planning_organization_id, -999) =
242: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))

Line 257: FROM mtl_consigned_qty_temp

253: -- invConv change : added secondary quantity
254: SELECT Nvl(sum(primary_quantity),0)
255: , Nvl(sum(secondary_quantity),0)
256: INTO l_qoh, l_sqoh
257: FROM mtl_consigned_qty_temp
258: WHERE organization_id = p_organization_id
259: AND inventory_item_id = p_inventory_item_id
260: AND Nvl(planning_organization_id, -999) =
261: Nvl(p_planning_org_id,Nvl(planning_organization_id, -999))

Line 277: FROM mtl_consigned_qty_temp

273: -- invConv change : added secondary quantity
274: SELECT Nvl(sum(primary_quantity),0)
275: , Nvl(sum(secondary_quantity),0)
276: INTO l_qoh, l_sqoh
277: FROM mtl_consigned_qty_temp
278: WHERE organization_id = p_organization_id
279: AND inventory_item_id = p_inventory_item_id
280: AND Nvl(planning_organization_id, -999) =
281: Nvl(p_planning_org_id,Nvl(planning_organization_id, -999))

Line 294: debug_print('After Querying mtl_consigned_qty_temp, qoh='||l_qoh||', sqoh='||l_sqoh||', item_type='||l_uom_ind);

290: AND locator_id = p_locator_id
291: AND cost_group_id = p_cost_group_id;
292: END IF;
293:
294: debug_print('After Querying mtl_consigned_qty_temp, qoh='||l_qoh||', sqoh='||l_sqoh||', item_type='||l_uom_ind);
295:
296: x_qoh := l_qoh;
297: -- invConv changes begin
298: IF (l_uom_ind = 'PS')

Line 1112: INSERT INTO mtl_consigned_qty_temp (organization_id,

1108: ll_transactable_vmi:=ll_primary_quantity;
1109: ll_transactable_secondary_vmi:=ll_secondary_quantity; -- InvConv change
1110: END IF;
1111:
1112: INSERT INTO mtl_consigned_qty_temp (organization_id,
1113: inventory_item_id,
1114: revision,
1115: lot_number,
1116: lot_expiration_date,

Line 1353: DELETE FROM mtl_consigned_qty_temp;

1349: IS
1350: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1351: BEGIN
1352: inv_quantity_tree_pub.clear_quantity_cache;
1353: DELETE FROM mtl_consigned_qty_temp;
1354: END clear_vmi_cache;
1355:
1356: /********************
1357: * Public API *

Line 1608: --SELECT COUNT(*)INTO l_table_count FROM mtl_consigned_qty_temp

1604: RETURN;
1605: END IF;
1606:
1607:
1608: --SELECT COUNT(*)INTO l_table_count FROM mtl_consigned_qty_temp
1609: --WHERE inventory_item_id = p_inventory_item_id
1610: --AND organization_id = p_organization_id;
1611: --Use Exists to check existance
1612: l_table_count := 0;

Line 1615: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp

1611: --Use Exists to check existance
1612: l_table_count := 0;
1613: BEGIN
1614: SELECT 1 INTO l_table_count FROM dual
1615: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp
1616: WHERE inventory_item_id = p_inventory_item_id
1617: AND organization_id = p_organization_id);
1618: EXCEPTION
1619: WHEN others THEN

Line 1912: INSERT INTO mtl_consigned_qty_temp ( organization_id,

1908:
1909: -- At this point we can insert another row into the vmi
1910: -- temp table.
1911:
1912: INSERT INTO mtl_consigned_qty_temp ( organization_id,
1913: inventory_item_id,
1914: revision,
1915: lot_number,
1916: lot_expiration_date,

Line 3902: --Bug#7001958. This proc populates mtl_consigned_qty_temp for LPN.

3898: END IF;
3899: END build_lpn_cursor;
3900:
3901:
3902: --Bug#7001958. This proc populates mtl_consigned_qty_temp for LPN.
3903: PROCEDURE populate_lpn_temp
3904: (
3905: p_organization_id IN NUMBER
3906: , p_inventory_item_id IN NUMBER

Line 4030: INSERT INTO mtl_consigned_qty_temp (organization_id,

4026: ELSE
4027: ll_transactable_vmi:=ll_primary_quantity;
4028: END IF;
4029:
4030: INSERT INTO mtl_consigned_qty_temp (organization_id,
4031: inventory_item_id,
4032: revision,
4033: lot_number,
4034: lot_expiration_date,

Line 4067: inv_log_util.trace('#of records inserted into mtl_consigned_qty_temp :'||l_count,'CONSIGNED_VALIDATIONS',9);

4063: ll_owning_organization_id);
4064: END LOOP;
4065:
4066: IF (l_debug = 1) THEN
4067: inv_log_util.trace('#of records inserted into mtl_consigned_qty_temp :'||l_count,'CONSIGNED_VALIDATIONS',9);
4068: END IF;
4069: dbms_sql.close_cursor(l_cursor);
4070: EXCEPTION
4071: WHEN OTHERS THEN

Line 4239: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp

4235: --Use Exists to check existance
4236: l_table_count := 0;
4237: BEGIN
4238: SELECT 1 INTO l_table_count FROM dual
4239: WHERE EXISTS (SELECT 1 FROM mtl_consigned_qty_temp
4240: WHERE inventory_item_id = p_inventory_item_id
4241: AND organization_id = p_organization_id);
4242: EXCEPTION
4243: WHEN others THEN

Line 4285: FROM mtl_consigned_qty_temp

4281: inv_log_util.trace('Query consigned temp table for l_vcoh','CONSIGNED_VALIDATIONS',9);
4282: END IF;
4283:
4284: SELECT Nvl(sum(primary_quantity),0) INTO l_vcoh
4285: FROM mtl_consigned_qty_temp
4286: WHERE organization_id = p_organization_id
4287: AND inventory_item_id = p_inventory_item_id
4288: AND Nvl(planning_organization_id, -999) = Nvl(p_planning_org_id,Nvl(planning_organization_id, -999))
4289: AND Nvl(owning_organization_id, -999) = Nvl(p_owning_org_id,Nvl(owning_organization_id, -999))