APPS.IBE_SHOP_LIST_PVT dependencies on IBE_SH_SHLITEM_RELS

Line 126: FROM ibe_sh_shlitem_rels R

122: l_list_line_id_tbl(l_list_line_id_tbl.LAST) := l_line_id;
123:
124: IF l_item_type_code = 'MDL' OR l_item_type_code = 'SVA' THEN
125: OPEN rel_line_csr FOR SELECT R.related_shp_list_item_id
126: FROM ibe_sh_shlitem_rels R
127: START WITH R.shp_list_item_id = l_line_id
128: CONNECT BY R.shp_list_item_id = PRIOR R.related_shp_list_item_id;
129: LOOP
130: FETCH rel_line_csr INTO l_rel_line_id;

Line 179: 'FROM ibe_sh_shlitem_rels ' ||

175: */
176: OPEN rel_line_csr FOR 'SELECT shp_list_item_id, '||
177: 'related_shp_list_item_id, ' ||
178: 'relationship_type_code ' ||
179: 'FROM ibe_sh_shlitem_rels ' ||
180: 'START WITH shp_list_item_id = :1 '||
181: 'CONNECT BY shp_list_item_id = PRIOR related_shp_list_item_id'
182: USING p_list_line_id_tbl(i);
183: LOOP

Line 255: ibe_sh_shlitem_rels R

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
259: FETCH l_csr INTO l_line_id,

Line 614: FROM ibe_sh_shlitem_rels ISSR,

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
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:

Line 765: SELECT IBE_SH_SHLITEM_RELS.SHLITEM_REL_ID

761: WHERE SHP_LIST_ID = l_Shp_List_Id;
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:

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 903: FROM IBE_SH_SHLITEM_RELS

899: l_shop_list_rel_line_id NUMBER;
900:
901: CURSOR c1 IS
902: SELECT RELATED_SHP_LIST_ITEM_ID
903: FROM IBE_SH_SHLITEM_RELS
904: WHERE SHP_LIST_ITEM_ID = p_Shp_List_Item_Id;
905:
906: CURSOR C_GET_REL_LINES(l_shp_list_line_id NUMBER) IS
907: SELECT SHLITEM_REL_ID

Line 908: FROM IBE_SH_SHLITEM_RELS

904: WHERE SHP_LIST_ITEM_ID = p_Shp_List_Item_Id;
905:
906: CURSOR C_GET_REL_LINES(l_shp_list_line_id NUMBER) IS
907: SELECT SHLITEM_REL_ID
908: FROM IBE_SH_SHLITEM_RELS
909: WHERE SHP_LIST_ITEM_ID = l_shp_list_line_id;
910:
911: BEGIN
912: -- DBMS_OUTPUT.PUT_LINE('Inside Delete_line p_Shp_List_Item_Id = ' || p_Shp_List_Item_Id);

Line 922: FROM IBE_SH_SHLITEM_RELS

918:
919: l_shp_list_item_id_tbl := jtf_number_table();
920:
921: SELECT COUNT(*) into l_count
922: FROM IBE_SH_SHLITEM_RELS
923: WHERE SHP_LIST_ITEM_ID = p_Shp_List_Item_Id;
924:
925: l_shp_list_item_id_tbl.extend(l_count);
926:

Line 2610: 'FROM ibe_sh_shlitem_rels ' ||

2606: l_component_code := TO_CHAR(x_qte_line_tbl(i).inventory_item_id);
2607:
2608: /* commented out on 5/21/03: SBM -- we won't be needing component code info
2609: OPEN l_csr FOR 'SELECT shp_list_item_id '||
2610: 'FROM ibe_sh_shlitem_rels ' ||
2611: 'START WITH related_shp_list_item_id = :1 '||
2612: 'CONNECT BY related_shp_list_item_id = PRIOR shp_list_item_id'
2613: USING p_list_line_id_tbl(k);
2614: LOOP