APPS.MSC_ITEM_PKG dependencies on MSC_TRADING_PARTNERS

Line 77: from msc_trading_partners o, msc_plans p

73: -- save owning organization's functional currency
74: begin
75: select o.currency_code
76: into l_owning_currency_code
77: from msc_trading_partners o, msc_plans p
78: where o.sr_instance_id=p.sr_instance_id
79: and o.sr_tp_id=p.organization_id
80: and o.partner_type=3
81: and p.plan_id=p_plan_id;

Line 1237: msc_trading_partners mtp,

1233: from msc_hub_query l,msc_hub_query p
1234: where l.query_id =l_qid_last_date and p.query_id=l_qid_pab
1235: and l.date3 = p.date3) pab,
1236: msc_system_items m1,
1237: msc_trading_partners mtp,
1238: msc_plans mp --- bug
1239: where pab.plan_id = m1.plan_id(+)
1240: and pab.sr_instance_id = m1.sr_instance_id(+)
1241: and pab.organization_id = m1.organization_id(+)

Line 1284: msc_trading_partners ss_mtp

1280: to_number(null) total_cost,
1281: to_number(null) inv_build_target
1282: from msc_hub_query ss,
1283: msc_hub_query ss_last,
1284: msc_trading_partners ss_mtp
1285: where ss.query_id = l_qid_ss
1286: and ss_last.query_id =l_qid_last_date
1287: and ss_last.date2 = ss.date1 -- for each last day,pick out its bkt_start_date
1288: and ss.number3 = ss_mtp.sr_instance_id

Line 1342: msc_trading_partners mil_mtp,

1338: to_number(null) inv_build_target
1339:
1340: from msc_hub_query mil_ss,
1341: msc_hub_query mil_last,
1342: msc_trading_partners mil_mtp,
1343: (select
1344: item.number1 plan_id,
1345: item.number2 plan_run_id,
1346: item.number3 sr_instance_id,

Line 1416: msc_trading_partners mtp2

1412:
1413: from msc_hub_query others,
1414: msc_hub_query others_vmi,
1415: msc_hub_query last_date1,
1416: msc_trading_partners mtp2
1417: where last_date1.query_id =l_qid_last_date
1418: and others_vmi.query_id(+) =l_qid_vmi_item
1419: and others.query_id = l_qid_others
1420: and others_vmi.number1(+) =others.number1

Line 1466: msc_trading_partners bis_mtp,

1462: ----------------------------------------------------------------------------
1463: from msc_bis_inv_detail mbid,
1464: msc_hub_query vmi,
1465: msc_hub_query map,
1466: msc_trading_partners bis_mtp,
1467: msc_plans mp
1468: where vmi.query_id(+) =l_qid_vmi_item
1469: and map.query_id = l_qid_week_map
1470: and map.date3 = trunc(mbid.detail_date)

Line 1572: msc_trading_partners bis_mtp,

1568: and vmi.number3(+) = msi_1.sr_instance_id
1569: and vmi.number4(+) = msi_1.organization_id
1570: and vmi.number5(+) = msi_1.inventory_item_id) msi_bis ,
1571: msc_hub_query map,
1572: msc_trading_partners bis_mtp,
1573: msc_plans mp
1574: where
1575: --vmi.query_id(+) =l_qid_vmi_item
1576: map.query_id = l_qid_week_map