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 INV_QUANTITY_TREE_PUB

Line 191: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

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')=
192: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
193: AND Nvl(planning_organization_id, -999) =
194: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))
195: AND NVL(owning_organization_id, -999) =

Line 192: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')

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')=
192: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
193: AND Nvl(planning_organization_id, -999) =
194: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))
195: AND NVL(owning_organization_id, -999) =
196: NVL(p_owning_org_id,Nvl(owning_organization_id, -999));

Line 207: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

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')=
208: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
209: AND NVL(planning_organization_id, -999) =
210: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))
211: AND Nvl(owning_organization_id, -999) =

Line 208: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')

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')=
208: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
209: AND NVL(planning_organization_id, -999) =
210: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))
211: AND Nvl(owning_organization_id, -999) =
212: NVL(p_owning_org_id,Nvl(owning_organization_id, -999))

Line 228: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

224: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))
225: AND Nvl(owning_organization_id, -999) =
226: NVL(p_owning_org_id,Nvl(owning_organization_id, -999))
227: AND
228: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
229: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
230: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
231: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'));
232: END IF;

Line 229: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')

225: AND Nvl(owning_organization_id, -999) =
226: NVL(p_owning_org_id,Nvl(owning_organization_id, -999))
227: AND
228: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
229: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
230: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
231: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'));
232: END IF;
233: IF(l_level =5)THEN

Line 246: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

242: NVL(p_planning_org_id,Nvl(planning_organization_id, -999))
243: AND Nvl(owning_organization_id, -999) =
244: NVL(p_owning_org_id,Nvl(owning_organization_id, -999))
245: AND
246: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
247: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
248: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
249: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'))
250: AND subinventory_code = p_subinventory_code;

Line 247: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')

243: AND Nvl(owning_organization_id, -999) =
244: NVL(p_owning_org_id,Nvl(owning_organization_id, -999))
245: AND
246: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
247: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
248: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
249: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'))
250: AND subinventory_code = p_subinventory_code;
251: END IF;

Line 265: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

261: Nvl(p_planning_org_id,Nvl(planning_organization_id, -999))
262: AND Nvl(owning_organization_id, -999) =
263: Nvl(p_owning_org_id,Nvl(owning_organization_id, -999))
264: AND
265: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
266: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
267: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
268: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'))
269: AND subinventory_code = p_subinventory_code

Line 266: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')

262: AND Nvl(owning_organization_id, -999) =
263: Nvl(p_owning_org_id,Nvl(owning_organization_id, -999))
264: AND
265: DECODE(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
266: DECODE(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
267: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
268: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'))
269: AND subinventory_code = p_subinventory_code
270: AND locator_id = p_locator_id ;

Line 285: Decode(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=

281: Nvl(p_planning_org_id,Nvl(planning_organization_id, -999))
282: AND Nvl(owning_organization_id, -999) =
283: Nvl(p_owning_org_id,Nvl(owning_organization_id, -999))
284: AND
285: Decode(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
286: Decode(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
287: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
288: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'))
289: AND subinventory_code = p_subinventory_code

Line 286: Decode(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')

282: AND Nvl(owning_organization_id, -999) =
283: Nvl(p_owning_org_id,Nvl(owning_organization_id, -999))
284: AND
285: Decode(p_tree_mode,INV_Quantity_Tree_PUB.g_loose_only_mode,containerized,'-1')=
286: Decode(p_tree_mode,inv_quantity_tree_pub.g_loose_only_mode,0,'-1')
287: AND Nvl(revision,'@@@') = Nvl(p_revision,Nvl(revision,'@@@'))
288: AND Nvl(lot_number,'@@@')=Nvl(p_lot_number,Nvl(lot_number,'@@@'))
289: AND subinventory_code = p_subinventory_code
290: AND locator_id = p_locator_id

Line 1352: inv_quantity_tree_pub.clear_quantity_cache;

1348: PROCEDURE clear_vmi_cache
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: /********************

Line 1507: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;

1503:
1504: x_return_status:= fnd_api.g_ret_sts_success;
1505:
1506: IF p_tree_mode IS NULL THEN
1507: l_tree_mode := INV_Quantity_Tree_PUB.g_loose_only_mode;
1508: ELSE l_tree_mode := p_tree_mode;
1509: END IF ;
1510:
1511: -- validate demand source info

Line 1698: inv_quantity_tree_pub.query_quantities(

1694: --togethor. The created tree is stored in the memory as a PL/SQL table.
1695: IF (l_debug = 1) THEN
1696: inv_log_util.trace('Transaction Mode, calling quantity tree','CONSIGNED_VALIDATIONS',9);
1697: END IF;
1698: inv_quantity_tree_pub.query_quantities(
1699: p_api_version_number => 1.0
1700: , p_init_msg_lst => fnd_api.g_false
1701: , x_return_status => x_return_status
1702: , x_msg_count => l_msg_count

Line 4308: inv_quantity_tree_pub.query_quantities(

4304: --togethor. The created tree is stored in the memory as a PL/SQL table.
4305: IF (l_debug = 1) THEN
4306: inv_log_util.trace('Transaction Mode, calling quantity tree','CONSIGNED_VALIDATIONS',9);
4307: END IF;
4308: inv_quantity_tree_pub.query_quantities(
4309: p_api_version_number => 1.0
4310: , p_init_msg_lst => fnd_api.g_false
4311: , x_return_status => x_return_status
4312: , x_msg_count => l_msg_count