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.IBE_SHOP_LIST_PVT dependencies on IBE_SH_SHP_LIST_ITEMS

Line 113: FROM ibe_sh_shp_list_items I

109: l_list_header_id := p_list_header_id_tbl(i);
110:
111: OPEN line_csr FOR SELECT I.shp_list_item_id,
112: I.item_type_code
113: FROM ibe_sh_shp_list_items I
114: WHERE I.shp_list_id = l_list_header_id
115: AND I.item_type_code NOT IN ('CFG', 'OPT', 'SRV');
116: LOOP
117: FETCH line_csr INTO l_line_id,

Line 254: FROM ibe_sh_shp_list_items L,

250: l_list_header_id := p_list_header_id_tbl(i);
251: OPEN l_csr FOR SELECT R.shp_list_item_id,
252: R.related_shp_list_item_id,
253: R.relationship_type_code
254: FROM ibe_sh_shp_list_items L,
255: ibe_sh_shlitem_rels R
256: WHERE L.shp_list_id = l_list_header_id
257: AND R.shp_list_item_id = L.shp_list_item_id;
258: LOOP

Line 400: FROM ibe_sh_shp_list_items

396: l_attribute12,
397: l_attribute13,
398: l_attribute14,
399: l_attribute15
400: FROM ibe_sh_shp_list_items
401: WHERE shp_list_item_id = p_list_line_id_tbl(k);
402:
403: IF p_combine_same_item = 'Y' AND l_item_type_code = 'STD' THEN
404: l_list_line_tbl_index := Find_Same_Item_In_Lst_Line_Tbl(

Line 433: FROM ibe_sh_shp_list_items

429: SELECT shp_list_item_id,
430: quantity
431: INTO l_list_line_id,
432: l_quantity
433: FROM ibe_sh_shp_list_items
434: WHERE shp_list_id = p_list_header_id
435: AND organization_id = l_organization_id
436: AND item_type_code = 'STD'
437: AND inventory_item_id = l_inventory_item_id

Line 446: * x_list_line_tbl nor in ibe_sh_shp_list_items table for the same item.

442: x_list_line_tbl(i).quantity := x_list_line_tbl(i).quantity + l_quantity;
443: EXCEPTION
444: /*
445: * We get to NO_DATA_FOUND block when there is no line in
446: * x_list_line_tbl nor in ibe_sh_shp_list_items table for the same item.
447: */
448: WHEN NO_DATA_FOUND THEN
449: x_list_line_tbl(i).operation_code := 'CREATE';
450: --commented by makulkar

Line 548: ' FROM ibe_sh_shp_list_items ' ||

544: l_list_line_ids VARCHAR2(300);
545: l_cursor_string CONSTANT VARCHAR2(200) := 'SELECT DISTINCT ' ||
546: 'config_header_id, ' ||
547: 'config_revision_num '||
548: ' FROM ibe_sh_shp_list_items ' ||
549: ' WHERE';
550:
551: BEGIN
552: IF p_shp_list_ids IS NOT NULL OR p_shp_list_line_ids IS NOT NULL THEN

Line 609: FROM ibe_sh_shp_list_items

605: l_usage_exists NUMBER;
606:
607: CURSOR C_GET_LIST_LINES(l_shp_list_id NUMBER) IS
608: SELECT shp_list_item_id
609: FROM ibe_sh_shp_list_items
610: WHERE shp_list_id = l_shp_list_id;
611:
612: CURSOR C_GET_REL_LINES(l_shp_list_id NUMBER) IS
613: SELECT ISSR.shlitem_rel_id

Line 615: ibe_sh_shp_list_items ISSLI

611:
612: CURSOR C_GET_REL_LINES(l_shp_list_id NUMBER) IS
613: SELECT ISSR.shlitem_rel_id
614: FROM ibe_sh_shlitem_rels ISSR,
615: ibe_sh_shp_list_items ISSLI
616: WHERE ISSR.shp_list_item_id = ISSLI.shp_list_item_id
617: AND ISSLI.shp_list_id = l_shp_list_id;
618:
619: BEGIN

Line 760: FROM IBE_SH_SHP_LIST_ITEMS

756:
757: CURSOR C_GET_LIST_LINES(l_shp_list_id NUMBER) IS
758:
759: SELECT SHP_LIST_ITEM_ID
760: FROM IBE_SH_SHP_LIST_ITEMS
761: WHERE SHP_LIST_ID = l_Shp_List_Id;
762:
763: CURSOR C_GET_REL_LINES(l_shp_list_id NUMBER) IS
764:

Line 766: FROM IBE_SH_SHLITEM_RELS, IBE_SH_SHP_LIST_ITEMS

762:
763: CURSOR C_GET_REL_LINES(l_shp_list_id NUMBER) IS
764:
765: SELECT IBE_SH_SHLITEM_RELS.SHLITEM_REL_ID
766: FROM IBE_SH_SHLITEM_RELS, IBE_SH_SHP_LIST_ITEMS
767: WHERE IBE_SH_SHLITEM_RELS.SHP_LIST_ITEM_ID = IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ITEM_ID
768: AND IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ID = l_Shp_List_Id;
769:
770: BEGIN

Line 767: WHERE IBE_SH_SHLITEM_RELS.SHP_LIST_ITEM_ID = IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ITEM_ID

763: CURSOR C_GET_REL_LINES(l_shp_list_id NUMBER) IS
764:
765: SELECT IBE_SH_SHLITEM_RELS.SHLITEM_REL_ID
766: FROM IBE_SH_SHLITEM_RELS, IBE_SH_SHP_LIST_ITEMS
767: WHERE IBE_SH_SHLITEM_RELS.SHP_LIST_ITEM_ID = IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ITEM_ID
768: AND IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ID = l_Shp_List_Id;
769:
770: BEGIN
771: -- Standard Start of API savepoint

Line 768: AND IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ID = l_Shp_List_Id;

764:
765: SELECT IBE_SH_SHLITEM_RELS.SHLITEM_REL_ID
766: FROM IBE_SH_SHLITEM_RELS, IBE_SH_SHP_LIST_ITEMS
767: WHERE IBE_SH_SHLITEM_RELS.SHP_LIST_ITEM_ID = IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ITEM_ID
768: AND IBE_SH_SHP_LIST_ITEMS.SHP_LIST_ID = l_Shp_List_Id;
769:
770: BEGIN
771: -- Standard Start of API savepoint
772: SAVEPOINT Delete_All_Lines_PVT;

Line 1044: from IBE_SH_SHP_LIST_ITEMS

1040: -- select shp_list_id to update object_version_number of the list
1041: IF l_count > 0 THEN
1042: BEGIN
1043: select SHP_LIST_ID into l_shop_list_id
1044: from IBE_SH_SHP_LIST_ITEMS
1045: where SHP_LIST_ITEM_ID = p_shop_list_line_ids(1);
1046: EXCEPTION
1047: WHEN NO_DATA_FOUND THEN
1048: FND_MESSAGE.set_name('IBE', 'IBE_SL_UPDATE_TO_LIST_ERROR');

Line 1316: FROM ibe_sh_shp_list_items

1312: AND l_combine_same_item = 'Y' THEN
1313: BEGIN
1314: SELECT shp_list_item_id, quantity
1315: INTO l_shp_list_item_id, l_quantity
1316: FROM ibe_sh_shp_list_items
1317: WHERE shp_list_id = p_sl_header_rec.shp_list_id
1318: AND inventory_item_id = l_sl_line_rec.inventory_item_id
1319: AND organization_id = l_sl_line_rec.organization_id
1320: AND uom_code = l_sl_line_rec.uom_code

Line 2458: FROM ibe_sh_shp_list_items

2454: l_attribute12,
2455: l_attribute13,
2456: l_attribute14,
2457: l_attribute15
2458: FROM ibe_sh_shp_list_items
2459: WHERE shp_list_item_id = p_list_line_id_tbl(k);
2460:
2461: -- added 3/26/03: avoid saving SRV info
2462: if (l_item_type_code <> 'SRV') then