APPS.AHL_OSP_SERV_ITEM_RELS_PVT dependencies on AHL_INV_SERVICE_ITEM_RELS

Line 156: FROM ahl_inv_service_item_rels

152: service_item_id ,
153: rank ,
154: active_start_date ,
155: active_end_date
156: FROM ahl_inv_service_item_rels
157: WHERE inv_service_item_rel_id = p_ser_item_rel_id
158: FOR UPDATE;
159:
160:

Line 164: FROM ahl_inv_service_item_rels

160:
161: CURSOR Item_Ser_rel_exists_csr(P_inv_org_id NUMBER,p_inv_item_id NUMBER,p_service_item_id NUMBER)
162: IS
163: SELECT 'X'
164: FROM ahl_inv_service_item_rels
165: WHERE inv_org_id = p_inv_org_id
166: AND inv_item_id = p_inv_item_id
167: AND service_item_id = p_service_item_id;
168:

Line 173: FROM ahl_inv_service_item_rels

169:
170: CURSOR Item_rank_exists_csr(P_inv_org_id NUMBER,p_inv_item_id NUMBER,p_rank NUMBER,p_serv_rel_id NUMBER)
171: IS
172: SELECT 'X'
173: FROM ahl_inv_service_item_rels
174: WHERE inv_org_id = p_inv_org_id
175: AND inv_item_id = p_inv_item_id
176: AND rank = p_rank
177: AND INV_SERVICE_ITEM_REL_ID <> NVL(p_serv_rel_id,-99);

Line 186: /* Removed the OU filtering here, as the view ahl_inv_service_item_rels_v itself is OU filtered with the Bug

182: isirv.inv_org_name,
183: isirv.inv_item_number,
184: isirv.service_item_number,
185: isirv.rank
186: /* Removed the OU filtering here, as the view ahl_inv_service_item_rels_v itself is OU filtered with the Bug
187: fix 5350882, mpothuku 26-Jul-06 */
188: FROM ahl_inv_service_item_rels_v isirv,
189: mtl_system_items_b mtl
190: /*

Line 188: FROM ahl_inv_service_item_rels_v isirv,

184: isirv.service_item_number,
185: isirv.rank
186: /* Removed the OU filtering here, as the view ahl_inv_service_item_rels_v itself is OU filtered with the Bug
187: fix 5350882, mpothuku 26-Jul-06 */
188: FROM ahl_inv_service_item_rels_v isirv,
189: mtl_system_items_b mtl
190: /*
191: inv_organization_info_v org
192: */

Line 493: DELETE FROM AHL_INV_SERVICE_ITEM_RELS

489: /* Commented by mpothuku on 25-jul-2005 to create the relationships in the Orgs where the relationship is
490: not already defined. The relationship if already existing is left intact.
491: */
492: /*
493: DELETE FROM AHL_INV_SERVICE_ITEM_RELS
494: WHERE INV_ITEM_ID = p_x_Inv_serv_item_rec.inv_item_id
495: AND SERVICE_ITEM_ID = p_x_Inv_serv_item_rec.service_item_id;
496: */
497:

Line 531: INSERT INTO AHL_INV_SERVICE_ITEM_RELS

527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Validation for Org, Inventory, Rank Check sucessful');
528: END IF;
529:
530:
531: INSERT INTO AHL_INV_SERVICE_ITEM_RELS
532: (INV_SERVICE_ITEM_REL_ID,
533: OBJECT_VERSION_NUMBER,
534: LAST_UPDATE_DATE ,
535: LAST_UPDATED_BY ,

Line 562: SELECT AHL_INV_SERVICE_ITEM_RELS_S.NEXTVAL,

558: ATTRIBUTE12 ,
559: ATTRIBUTE13 ,
560: ATTRIBUTE14 ,
561: ATTRIBUTE15 )
562: SELECT AHL_INV_SERVICE_ITEM_RELS_S.NEXTVAL,
563: 1,
564: sysdate,
565: Fnd_Global.USER_ID,
566: sysdate,

Line 604: (select INV_ORG_ID from AHL_INV_SERVICE_ITEM_RELS

600: AND Inv.inventory_item_id = p_x_Inv_serv_item_rec.inv_item_id
601: AND Serv.inventory_item_id = p_x_Inv_serv_item_rec.service_item_id
602: -- mpothuku start
603: AND org.organization_id not in
604: (select INV_ORG_ID from AHL_INV_SERVICE_ITEM_RELS
605: where inv_item_id = p_x_Inv_serv_item_rec.inv_item_id
606: AND service_item_id = p_x_Inv_serv_item_rec.service_item_id)
607: -- mpothuku end
608: AND NVL(org.operating_unit, mo_global.get_current_org_id()) =

Line 617: INSERT INTO AHL_INV_SERVICE_ITEM_RELS

613: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Inserting Relationship in Single Org');
615: END IF;
616:
617: INSERT INTO AHL_INV_SERVICE_ITEM_RELS
618: (INV_SERVICE_ITEM_REL_ID,
619: OBJECT_VERSION_NUMBER,
620: LAST_UPDATE_DATE ,
621: LAST_UPDATED_BY ,

Line 649: (AHL_INV_SERVICE_ITEM_RELS_S.NEXTVAL,

645: ATTRIBUTE13 ,
646: ATTRIBUTE14 ,
647: ATTRIBUTE15 )
648: VALUES
649: (AHL_INV_SERVICE_ITEM_RELS_S.NEXTVAL,
650: 1,
651: sysdate,
652: Fnd_Global.USER_ID,
653: sysdate,

Line 696: UPDATE ahl_inv_service_item_rels

692: RAISE Fnd_Api.g_exc_error;
693: END IF;
694: -- mpothuku End
695:
696: UPDATE ahl_inv_service_item_rels
697: SET active_start_date = p_x_inv_serv_item_rec.active_start_date,
698: active_end_date = p_x_inv_serv_item_rec.active_end_date,
699: rank = p_x_inv_serv_item_rec.rank,
700: object_version_number = object_version_number +1

Line 713: DELETE FROM ahl_inv_service_item_rels

709:
710:
711: ELSIF p_x_Inv_serv_item_rec.operation_flag = 'D' THEN
712:
713: DELETE FROM ahl_inv_service_item_rels
714: WHERE inv_service_item_rel_id = p_x_Inv_serv_item_rec.inv_ser_item_rel_id
715: AND object_version_number = l_Item_Ser_rel_det.object_version_number;
716:
717: IF SQL%ROWCOUNT = 0 THEN