APPS.MSD_ITEM_RELATIONSHIPS_PKG dependencies on MSD_ST_ITEM_RELATIONSHIPS

Line 29: delete from msd_st_item_relationships

25: end if;
26:
27: /* Delete records by instance before collecting supersession data from source instance */
28:
29: delete from msd_st_item_relationships
30: where instance_id = p_instance_id;
31:
32: /* Single step collection internally is two step hence colect always inserts it in staging table */
33: /* Net Change is not needed for this entity */

Line 35: v_sql_stmt:= ' insert into msd_st_item_relationships ( '||

31:
32: /* Single step collection internally is two step hence colect always inserts it in staging table */
33: /* Net Change is not needed for this entity */
34:
35: v_sql_stmt:= ' insert into msd_st_item_relationships ( '||
36: 'instance_id, '||
37: 'inventory_item_id, '||
38: 'inventory_item, '||
39: 'related_item_id, '||

Line 98: from msd_st_item_relationships;

94: and introduction_type = 2;
95:
96: CURSOR item_instance_c2 IS
97: select distinct instance_id
98: from msd_st_item_relationships;
99:
100: BEGIN
101:
102: OPEN item_instance_c2;

Line 143: FROM msd_st_item_relationships

139: FND_GLOBAL.USER_ID,
140: FND_GLOBAL.USER_ID,
141: start_date, /*--Bug#4707819--*/
142: end_date /*--Bug#4707819--*/
143: FROM msd_st_item_relationships
144: WHERE instance_id = l_instance_id;
145:
146: commit;
147: