APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ST_SALES_ORDERS

Line 2497: FROM MSC_ST_SALES_ORDERS so

2493: DELETE FROM MSC_SALES_ORDERS
2494: WHERE ROW_TYPE = 3
2495: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2496: AND SR_DEMAND_ID IN (SELECT so.DEMAND_ID
2497: FROM MSC_ST_SALES_ORDERS so
2498: WHERE so.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2499: AND so.ROW_TYPE = 2 )
2500: AND ROWNUM <= ln_rows_to_fetch;
2501: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE1 ROWSDELETED :'||SQL%rowcount);

Line 2510: FROM MSC_ST_SALES_ORDERS so

2506: LOOP
2507: DELETE FROM MSC_SALES_ORDERS
2508: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2509: AND (ROW_TYPE,SR_DEMAND_ID) IN (SELECT so.ROW_TYPE,so.DEMAND_ID
2510: FROM MSC_ST_SALES_ORDERS so
2511: WHERE so.DELETED_FLAG = 1
2512: AND so.sr_instance_id = MSC_CL_COLLECTION.v_instance_id)
2513: AND ROWNUM <= ln_rows_to_fetch;
2514: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE2 ROWSDELETED :'||SQL%rowcount);

Line 2612: MSC_ST_SALES_ORDERS so,

2608: lv_sql1_3:='
2609: FROM MSC_ITEM_ID_LID t1,
2610: MSC_ITEM_ID_LID t2,
2611: MSC_ITEM_ID_LID t3,
2612: MSC_ST_SALES_ORDERS so,
2613: MSC_TP_ID_LID mtil,
2614: MSC_TP_SITE_ID_LID mtsila,
2615: MSC_TP_SITE_ID_LID mtsilb
2616: WHERE t1.SR_INVENTORY_ITEM_ID= so.INVENTORY_ITEM_ID

Line 2938: from msc_st_sales_orders msso

2934: END IF;
2935: -- Update Reservation Qty
2936:
2937: FOR modified_resv IN ( select distinct msso.demand_source_line
2938: from msc_st_sales_orders msso
2939: where msso.sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2940: AND ROW_TYPE=1
2941: and msso.demand_source_line IS NOT NULL
2942: and msso.reservation_type = 2