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_ATP_PF dependencies on MSC_TRADING_PARTNERS

Line 2738: MSC_TRADING_PARTNERS MTP,--bug3263368

2734: MSC_DEMANDS D,
2735: MSC_ATP_RULES R,
2736: MSC_SYSTEM_ITEMS I,
2737: MSC_SYSTEM_ITEMS I0,
2738: MSC_TRADING_PARTNERS MTP,--bug3263368
2739: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2740: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2741: AND I0.ORGANIZATION_ID = p_org_id
2742: AND I0.SR_INSTANCE_ID = p_instance_id

Line 2829: MSC_TRADING_PARTNERS MTP,--bug3263368

2825: MSC_ATP_RULES R,
2826: MSC_SYSTEM_ITEMS I,
2827: MSC_SYSTEM_ITEMS I0,
2828: MSC_CALENDAR_DATES C,
2829: MSC_TRADING_PARTNERS MTP,--bug3263368
2830: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
2831: WHERE I0.SR_INVENTORY_ITEM_ID = p_item_id
2832: AND I0.ORGANIZATION_ID = p_org_id
2833: AND I0.SR_INSTANCE_ID = p_instance_id

Line 3197: MSC_TRADING_PARTNERS MTP,--bug3263368

3193:
3194: FROM MSC_SYSTEM_ITEMS I,
3195: MSC_SYSTEM_ITEMS I2, --bug3579625
3196: MSC_ALLOC_DEMANDS AD,
3197: MSC_TRADING_PARTNERS MTP,--bug3263368
3198: MSC_TRADING_PARTNER_SITES MTPS --bug3263368
3199: WHERE I.SR_INVENTORY_ITEM_ID in (p_sr_member_id, p_sr_family_id)
3200: AND I.ORGANIZATION_ID = p_org_id
3201: AND I.SR_INSTANCE_ID = p_instance_id

Line 5152: MSC_TRADING_PARTNERS MTP,--bug3263368

5148: AD.DEMAND_CLASS, --bug3263368
5149: AD.REQUEST_DATE, --bug3263368
5150: I.Item_Name -- bug3579625
5151: FROM MSC_ALLOC_DEMANDS AD,
5152: MSC_TRADING_PARTNERS MTP,--bug3263368
5153: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
5154: MSC_SYSTEM_ITEMS I --bug3579625
5155: WHERE AD.PLAN_ID = p_plan_id
5156: AND AD.SR_INSTANCE_ID = p_instance_id

Line 5663: MSC_TRADING_PARTNERS MTP,--bug3263368

5659: AD.DEMAND_CLASS, --bug3263368
5660: AD.REQUEST_DATE, --bug3263368
5661: I.Item_Name --bug3579625
5662: FROM MSC_ALLOC_DEMANDS AD,
5663: MSC_TRADING_PARTNERS MTP,--bug3263368
5664: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
5665: MSC_SYSTEM_ITEMS I --bug3579625
5666: WHERE AD.PLAN_ID = p_plan_id
5667: AND AD.SR_INSTANCE_ID = p_instance_id

Line 5735: MSC_TRADING_PARTNERS MTP,--bug3684383

5731: I.Item_Name --bug3579625
5732:
5733: FROM MSC_ALLOC_SUPPLIES SA,
5734: MSC_SYSTEM_ITEMS I, --bug3579625
5735: MSC_TRADING_PARTNERS MTP,--bug3684383
5736: MSC_TRADING_PARTNER_SITES MTPS --bug3684383
5737:
5738: WHERE SA.PLAN_ID = p_plan_id
5739: AND SA.SR_INSTANCE_ID = p_instance_id

Line 6096: MSC_TRADING_PARTNERS MTP,--bug3263368

6092: AD.REQUEST_DATE col30 --bug3263368
6093: FROM
6094: MSC_ALLOC_DEMANDS AD,
6095: MSC_ALLOC_TEMP TEMP,
6096: MSC_TRADING_PARTNERS MTP,--bug3263368
6097: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
6098: MSC_SYSTEM_ITEMS msi --bug3671294
6099: WHERE
6100: AD.PLAN_ID = p_plan_id

Line 6163: MSC_TRADING_PARTNERS MTP --bug3684383

6159: MSC_ALLOC_SUPPLIES SA,
6160: MSC_ALLOC_TEMP TEMP,
6161: MSC_SYSTEM_ITEMS msi, --bug3671294
6162: MSC_TRADING_PARTNER_SITES MTPS, --bug3684383
6163: MSC_TRADING_PARTNERS MTP --bug3684383
6164: WHERE
6165: SA.PLAN_ID = p_plan_id
6166: AND SA.SR_INSTANCE_ID = p_instance_id
6167: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)

Line 6656: MSC_TRADING_PARTNERS MTP,--bug3263368

6652: AD.REQUEST_DATE col31 --bug3263368
6653: FROM
6654: MSC_ALLOC_DEMANDS AD,
6655: MSC_ALLOC_TEMP TEMP,
6656: MSC_TRADING_PARTNERS MTP,--bug3263368
6657: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
6658: MSC_SYSTEM_ITEMS msi --bug3671294
6659: WHERE
6660: AD.PLAN_ID = p_plan_id

Line 7167: MSC_TRADING_PARTNERS MTP,--bug3263368

7163: AD.REQUEST_DATE col36 --bug3263368
7164: FROM
7165: MSC_ALLOC_DEMANDS AD,
7166: MSC_ALLOC_HIERARCHY_TEMP TEMP,
7167: MSC_TRADING_PARTNERS MTP,--bug3263368
7168: MSC_TRADING_PARTNER_SITES MTPS, --bug3263368
7169: MSC_SYSTEM_ITEMS msi --bug3671294
7170: WHERE
7171: AD.PLAN_ID = p_plan_id

Line 8622: msc_trading_partners tp

8618: INTO l_atf_days
8619: FROM msc_system_items i2,
8620: msc_system_items i1,
8621: msc_atp_rules r,
8622: msc_trading_partners tp
8623: WHERE i1.inventory_item_id = p_inventory_item_id
8624: AND i1.organization_id = p_organization_id
8625: AND i1.plan_id = -1
8626: AND i1.sr_instance_id = p_instance_id

Line 8921: msc_trading_partners tp,

8917: BULK COLLECT INTO l_atf_date,l_organization_id,l_sr_instance_id,l_inventory_item_id
8918: FROM msc_plans mp,
8919: msc_plan_organizations po,
8920: msc_system_items i2,
8921: msc_trading_partners tp,
8922: msc_atp_rules r,
8923: msc_calendar_dates c1,
8924: msc_calendar_dates c2
8925: WHERE mp.plan_id = p_plan_id

Line 8988: msc_trading_partners tp,

8984: (SELECT c2.calendar_date
8985: FROM msc_calendar_dates c2,
8986: msc_calendar_dates c1,
8987: msc_atp_rules r,
8988: msc_trading_partners tp,
8989: msc_plans mp,
8990: msc_system_items i2
8991: WHERE i2.inventory_item_id = i.inventory_item_id
8992: AND i2.organization_id = i.organization_id