eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_CL_PRE_PROCESS dependencies on MSC_TRADING_PARTNERS

Line 6916: (SELECT mtp.organization_code from msc_trading_partners mtp

6912: AND mstp.sr_instance_code = v_instance_code
6913: AND mstp.batch_id = lv_batch_id
6914: AND mstp.partner_type = G_ORGANIZATION
6915: AND EXISTS -- check against those orgs which do not belong to this company
6916: (SELECT mtp.organization_code from msc_trading_partners mtp
6917: WHERE mstp.organization_code = mtp.organization_code
6918: AND mtp.sr_instance_id = v_instance_id
6919: AND mtp.partner_type = G_ORGANIZATION
6920: MINUS

Line 7335: ||' FROM msc_trading_partners mtp,'

7331: 'UPDATE msc_st_trading_partners mstp'
7332: ||' SET process_flag = '||G_ERROR_FLG||','
7333: ||' error_text = '||''''||lv_message_text||''''
7334: ||' WHERE EXISTS(SELECT 1 '
7335: ||' FROM msc_trading_partners mtp,'
7336: ||' msc_company_id_lid mcil'
7337: ||' WHERE mtp.partner_name = mstp.partner_name'
7338: ||' AND mtp.partner_type = mstp.partner_type'
7339: ||' AND mtp.organization_code <> mstp.organization_code'

Line 7365: ||' FROM msc_trading_partners mtp'

7361: 'UPDATE msc_st_trading_partners mstp'
7362: ||' SET process_flag = '||G_ERROR_FLG||','
7363: ||' error_text = '||''''||lv_message_text||''''
7364: ||' WHERE EXISTS(SELECT 1 '
7365: ||' FROM msc_trading_partners mtp'
7366: ||' WHERE mtp.partner_name = mstp.partner_name'
7367: ||' AND mtp.partner_type = mstp.partner_type'
7368: ||' AND mtp.organization_code <> mstp.organization_code'
7369: ||' AND nvl(mtp.company_id,1) = 1)'

Line 24130: msc_trading_partners mtp,

24126: ||' AND EXISTS (SELECT msn.serial_txn_id
24127: FROM msc_serial_numbers msn,
24128: msc_sup_dem_entries msde,
24129: msc_trading_partner_maps mtpm,
24130: msc_trading_partners mtp,
24131: msc_item_id_lid miil,
24132: msc_apps_instances mai
24133: WHERE msde.inventory_item_id = miil.inventory_item_id
24134: AND miil.sr_inventory_item_id = mssi.sr_inventory_item_id

Line 32390: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '

32386:
32387: lv_sql_stmt :=
32388: 'UPDATE msc_st_resource_shifts msrs'
32389: ||' SET shift_num =(SELECT mlis.local_id'
32390: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
32391: ||' WHERE mtp.sr_instance_id = '||v_instance_id
32392: ||' AND mlis.char1 = msrs.sr_instance_code'
32393: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
32394: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '

Line 32968: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '

32964:
32965: lv_sql_stmt :=
32966: 'UPDATE msc_st_resource_changes msrc'
32967: ||' SET shift_num =(SELECT mlis.local_id'
32968: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
32969: ||' WHERE mtp.sr_instance_id = '||v_instance_id
32970: ||' AND mlis.char1 = msrc.sr_instance_code'
32971: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
32972: ||' = NVL(msrc.company_name,'||''''||NULL_CHAR||''''||') '

Line 34471: FROM msc_trading_partners mtp

34467:
34468: UPDATE MSC_ST_SUPPLIES t1
34469: SET PLANNING_PARTNER_SITE_ID =
34470: (SELECT sr_tp_id
34471: FROM msc_trading_partners mtp
34472: WHERE mtp.partner_type = G_ORGANIZATION
34473: AND mtp.organization_code = v_instance_code||':'||t1.PLANNING_PARTNER_SITE_CODE
34474: AND mtp.sr_instance_id =v_instance_id)
34475: WHERE t1.sr_instance_code = v_instance_code

Line 34522: FROM msc_trading_partners mtp

34518:
34519: UPDATE MSC_ST_SUPPLIES t1
34520: SET OWNING_PARTNER_SITE_ID =
34521: (SELECT sr_tp_id
34522: FROM msc_trading_partners mtp
34523: WHERE mtp.partner_type = G_ORGANIZATION
34524: AND mtp.organization_code = v_instance_code||':'||t1.OWNING_PARTNER_SITE_CODE
34525: AND mtp.sr_instance_id =v_instance_id)
34526: WHERE t1.sr_instance_code = v_instance_code

Line 54111: FROM msc_period_start_dates mpsd,msc_trading_partners mtp

54107: v_current_date,
54108: v_current_user,
54109: v_current_date,
54110: v_current_user
54111: FROM msc_period_start_dates mpsd,msc_trading_partners mtp
54112: WHERE mpsd.calendar_code = mtp.calendar_code
54113: AND mpsd.sr_instance_id = mtp.sr_instance_id
54114: AND mtp.partner_type = G_ORGANIZATION
54115: AND mtp.sr_instance_id = v_instance_id

Line 54174: FROM msc_trading_partners mtpo

54170: AND mtp.partner_type = G_ORGANIZATION
54171: AND mtp.process_flag = G_VALID
54172: AND mtp.sr_instance_id = v_instance_id
54173: AND NOT EXISTS(SELECT 1
54174: FROM msc_trading_partners mtpo
54175: WHERE mtpo.sr_instance_id = mtp.sr_instance_id
54176: AND mtpo.partner_type = mtp.partner_type
54177: AND mtpo.sr_tp_id = mtp.sr_tp_id)
54178: );

Line 55361: -- check customer exists in msc_trading_partners

55357: IF lv_return <> 0 THEN
55358: RAISE ex_logging_err;
55359: END IF;
55360:
55361: -- check customer exists in msc_trading_partners
55362: -- Set the message
55363:
55364: v_sql_stmt := 12;
55365: