APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ST_SALES_ORDERS

Line 2196: FROM MSC_ST_SALES_ORDERS so

2192: DELETE FROM MSC_SALES_ORDERS
2193: WHERE ROW_TYPE = 3
2194: AND sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2195: AND SR_DEMAND_ID IN (SELECT so.DEMAND_ID
2196: FROM MSC_ST_SALES_ORDERS so
2197: WHERE so.sr_instance_id = MSC_CL_COLLECTION.v_instance_id
2198: AND so.ROW_TYPE = 2 )
2199: AND ROWNUM <= ln_rows_to_fetch;
2200: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE1 ROWSDELETED :'||SQL%rowcount);

Line 2209: FROM MSC_ST_SALES_ORDERS so

2205: LOOP
2206: DELETE FROM MSC_SALES_ORDERS
2207: WHERE SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2208: AND (ROW_TYPE,SR_DEMAND_ID) IN (SELECT so.ROW_TYPE,so.DEMAND_ID
2209: FROM MSC_ST_SALES_ORDERS so
2210: WHERE so.DELETED_FLAG = 1
2211: AND so.sr_instance_id = MSC_CL_COLLECTION.v_instance_id)
2212: AND ROWNUM <= ln_rows_to_fetch;
2213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'NetCHg DELETE2 ROWSDELETED :'||SQL%rowcount);

Line 2303: MSC_ST_SALES_ORDERS so,

2299: lv_sql1_3:='
2300: FROM MSC_ITEM_ID_LID t1,
2301: MSC_ITEM_ID_LID t2,
2302: MSC_ITEM_ID_LID t3,
2303: MSC_ST_SALES_ORDERS so,
2304: MSC_TP_ID_LID mtil,
2305: MSC_TP_SITE_ID_LID mtsila,
2306: MSC_TP_SITE_ID_LID mtsilb
2307: WHERE t1.SR_INVENTORY_ITEM_ID= so.INVENTORY_ITEM_ID

Line 2606: from msc_st_sales_orders msso

2602: END IF;
2603: -- Update Reservation Qty
2604:
2605: FOR modified_resv IN ( select distinct msso.demand_source_line
2606: from msc_st_sales_orders msso
2607: where msso.sr_instance_id= MSC_CL_COLLECTION.v_instance_id
2608: AND ROW_TYPE=1
2609: and msso.demand_source_line IS NOT NULL
2610: and msso.reservation_type = 2