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 11550: -- 1. No union with MSC_SUPPLIER_CAPACITIES

11546:
11547: UNION ALL
11548:
11549: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11550: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11551: -- 2. MSC_PLANS included in the join to get latest refresh number
11552: -- 3. Filter records based on refresh_number
11553: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11554: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,

Line 11608: -- 1. No union with MSC_SUPPLIER_CAPACITIES

11604:
11605: UNION ALL
11606:
11607: -- Summary enhancement : differences from non summary SQL: ship/rec cal changes pending
11608: -- 1. No union with MSC_SUPPLIER_CAPACITIES
11609: -- 2. MSC_PLANS included in the join to get latest refresh number
11610: -- 3. Filter records based on refresh_number
11611: --Fixing as a part of bug3709707 adding trunc so that 2 column are not seen in HP
11612: SELECT TRUNC(Decode(p_sup_atp_info_rec.sup_cap_type,

Line 11672: msc_supplier_capacities s

11668: p_sup_atp_info_rec.supplier_site_id,
11669: -- ship_rec_cal
11670: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11671: FROM msc_calendar_dates c,
11672: msc_supplier_capacities s
11673: WHERE s.inventory_item_id = l_inv_item_id
11674: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11675: AND s.plan_id = p_sup_atp_info_rec.plan_id
11676: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 11758: msc_supplier_capacities s

11754: p_sup_atp_info_rec.supplier_site_id,
11755: -- ship_rec_cal
11756: c.seq_num - p_sup_atp_info_rec.sysdate_seq_num),0))) quantity
11757: FROM msc_calendar_dates c,
11758: msc_supplier_capacities s
11759: WHERE s.inventory_item_id = p_sup_atp_info_rec.inventory_item_id
11760: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11761: AND s.plan_id = p_sup_atp_info_rec.plan_id
11762: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 11908: msc_supplier_capacities s

11904: l_sysdate,
11905: FND_GLOBAL.User_ID,
11906: FND_GLOBAL.User_ID
11907: FROM msc_calendar_dates c,
11908: msc_supplier_capacities s
11909: WHERE s.inventory_item_id = l_inv_item_id
11910: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
11911: AND s.plan_id = p_sup_atp_info_rec.plan_id
11912: AND s.organization_id = p_sup_atp_info_rec.organization_id

Line 12078: msc_supplier_capacities s

12074: l_sysdate,
12075: FND_GLOBAL.User_ID,
12076: FND_GLOBAL.User_ID
12077: FROM msc_calendar_dates c,
12078: msc_supplier_capacities s
12079: WHERE s.inventory_item_id = l_inv_item_id
12080: AND s.sr_instance_id = p_sup_atp_info_rec.instance_id
12081: AND s.plan_id = p_sup_atp_info_rec.plan_id
12082: AND s.organization_id = p_sup_atp_info_rec.organization_id