APPS.MSD_TRANSLATE_LEVEL_VALUES dependencies on MSD_ST_ITEM_LIST_PRICE

Line 1186: delete from msd_st_item_list_price

1182: retcode,
1183: p_instance_id,
1184: p_seq_num);
1185:
1186: delete from msd_st_item_list_price
1187: where instance = p_instance_id;
1188:
1189:
1190: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then

Line 1194: delete from msd_st_item_list_price

1190: ELSIF (p_dest_table = MSD_COMMON_UTILITIES.LEVEL_VALUES_STAGING_TABLE) then
1191:
1192: /* Collection */
1193: IF (p_level_id = 1) THEN
1194: delete from msd_st_item_list_price
1195: where instance = p_instance_id;
1196: END IF;
1197:
1198: msd_common_utilities.get_db_link(p_instance_id, x_dblink, retcode);

Line 1204: v_sql_stmt:= ' insert into msd_st_item_list_price ( '||

1200: retcode :=-1;
1201: return;
1202: end if;
1203:
1204: v_sql_stmt:= ' insert into msd_st_item_list_price ( '||
1205: 'instance, '||
1206: 'item, '||
1207: 'sr_item_pk, '||
1208: 'list_price, '||

Line 1273: from msd_st_item_list_price

1269: from msd_item_list_price
1270: where instance = p_instance_id
1271: MINUS
1272: select sr_item_pk
1273: from msd_st_item_list_price
1274: where instance = p_instance_id);
1275:
1276: TYPE sr_item_pk_tab is table of msd_item_list_price.sr_item_pk%TYPE;
1277:

Line 1329: from msd_st_item_list_price

1325:
1326: CURSOR c_st_rows IS
1327: select item, list_price, avg_discount, base_uom,
1328: sr_item_pk, item_type_id, forecast_type_id
1329: from msd_st_item_list_price
1330: where instance = p_instance_id;
1331:
1332:
1333: CURSOR c_fact_rows (p_item_pk VARCHAR2) IS