DBA Data[Home] [Help]

APPS.MSD_CL_PRE_PROCESS dependencies on MSC_LOCAL_ID_SETUP

Line 2415: FROM msc_local_id_setup mls

2411: UPDATE msd_st_booking_data mbd
2412: SET process_flag = G_ERROR_FLG,
2413: error_text = lv_message_text
2414: WHERE NOT EXISTS(SELECT 1
2415: FROM msc_local_id_setup mls
2416: WHERE mls.char1 = mbd.sr_instance_code
2417: AND nvl(mls.char2,lv_my_company) = lv_my_company
2418: AND mls.char3 = mbd.customer
2419: AND mls.char4 = mbd.ship_to_loc

Line 3304: FROM msc_local_id_setup mls

3300: UPDATE msd_st_shipment_data msd
3301: SET process_flag = G_ERROR_FLG,
3302: error_text = lv_message_text
3303: WHERE NOT EXISTS(SELECT 1
3304: FROM msc_local_id_setup mls
3305: WHERE mls.char1 = msd.sr_instance_code
3306: AND nvl(mls.char2,lv_my_company) = lv_my_company
3307: AND mls.char3 = msd.customer
3308: AND mls.char4 = msd.ship_to_loc