APPS.MSC_M2A_PUSH dependencies on MSC_TRADING_PARTNER_SITES

Line 928: from msc_trading_partner_sites

924: END IF;
925:
926: IF pSUPPLIER_SITE_ID IS NOT NULL THEN
927: select sr_tp_site_id into lv_sr_tp_site_id
928: from msc_trading_partner_sites
929: where partner_id = pSUPPLIER_ID
930: and partner_site_id = pSUPPLIER_SITE_ID
931: and sr_instance_id = pINSTANCE_ID;
932: END IF;

Line 1302: table msc_trading_partner_sites. */

1298:
1299: /*This is for Buy Orders, Will always be executed */
1300: /* Bug # 2271832 (new bug for 2101174),
1301: replacing the view mrp_ap_organizations_v with the
1302: table msc_trading_partner_sites. */
1303:
1304: lv_sql_stmt:=
1305: 'INSERT INTO MRP_RECOMMENDATIONS'||v_dblink
1306: ||'( TRANSACTION_ID , '