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_REQ dependencies on MSC_SUPPLIER_CAPACITIES

Line 11517: -- 1. No union with MSC_SUPPLIER_CAPACITIES

11513:
11514: UNION ALL
11515:
11516: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11517: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11518: -- 2. MSC_PLANS included in the join to get latest refresh number
11519: -- 3. Filter records based on refresh_number
11520: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11521: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,

Line 11575: -- 1. No union with MSC_SUPPLIER_CAPACITIES

11571:
11572: UNION ALL
11573:
11574: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11575: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11576: -- 2. MSC_PLANS included in the join to get latest refresh number
11577: -- 3. Filter records based on refresh_number
11578: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11579: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,

Line 11639: msc_supplier_capacities s

11635: p_sup_atp_info_rec.supplier_site_id,
11636: -- ship_rec_cal
11637: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11638: FROM msc_calendar_dates c,
11639: msc_supplier_capacities s
11640: WHERE s.inventory_item_id = l_inv_item_id
11641: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11642: AND s.plan_id = p_sup_atp_info_rec.plan_id
11643: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 11725: msc_supplier_capacities s

11721: p_sup_atp_info_rec.supplier_site_id,
11722: -- ship_rec_cal
11723: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11724: FROM msc_calendar_dates c,
11725: msc_supplier_capacities s
11726: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
11727: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11728: AND s.plan_id = p_sup_atp_info_rec.plan_id
11729: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 11875: msc_supplier_capacities s

11871: l_sysdate,
11872: FND_GLOBAL.User_ID,
11873: FND_GLOBAL.User_ID
11874: FROM msc_calendar_dates c,
11875: msc_supplier_capacities s
11876: WHERE s.inventory_item_id = l_inv_item_id
11877: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11878: AND s.plan_id = p_sup_atp_info_rec.plan_id
11879: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 12045: msc_supplier_capacities s

12041: l_sysdate,
12042: FND_GLOBAL.User_ID,
12043: FND_GLOBAL.User_ID
12044: FROM msc_calendar_dates c,
12045: msc_supplier_capacities s
12046: WHERE s.inventory_item_id = l_inv_item_id
12047: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
12048: AND s.plan_id = p_sup_atp_info_rec.plan_id
12049: AND s.organization_id = p_sup_atp_info_rec.organization_id