APPS.MSC_ATP_PF dependencies on MSC_TRADING_PARTNER_SITES

Line 2739: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

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
2743: AND I0.PLAN_ID = p_plan_id

Line 2830: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

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
2834: AND I0.PLAN_ID = p_plan_id

Line 3198: MSC_TRADING_PARTNER_SITES MTPS --bug3263368

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
3202: AND I.PLAN_ID = p_plan_id

Line 5153: MSC_TRADING_PARTNER_SITES MTPS, --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
5157: AND AD.INVENTORY_ITEM_ID in (p_member_id,p_family_id)

Line 5664: MSC_TRADING_PARTNER_SITES MTPS, --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
5668: AND AD.INVENTORY_ITEM_ID in (p_member_id, p_family_id)

Line 5736: MSC_TRADING_PARTNER_SITES MTPS --bug3684383

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
5740: AND SA.INVENTORY_ITEM_ID in (p_member_id, p_family_id)

Line 6097: MSC_TRADING_PARTNER_SITES MTPS, --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
6101: AND AD.SR_INSTANCE_ID = p_instance_id

Line 6162: MSC_TRADING_PARTNER_SITES MTPS, --bug3684383

6158: FROM
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

Line 6657: MSC_TRADING_PARTNER_SITES MTPS, --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
6661: AND AD.SR_INSTANCE_ID = p_instance_id

Line 7168: MSC_TRADING_PARTNER_SITES MTPS, --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
7172: AND AD.SR_INSTANCE_ID = p_instance_id