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_PROC dependencies on MSC_SOURCES_V

Line 718: -- ODS, use msc_sources_v

714: HAVING count(*) = l_count
715: ORDER BY 5;
716:
717: ELSE
718: -- ODS, use msc_sources_v
719: IF PG_DEBUG in ('Y', 'C') THEN
720: msc_sch_wb.atp_debug('Atp_Sources: ' || 'We are in ODS, using msc_sources_v for sources.');
721: END IF;
722:

Line 720: msc_sch_wb.atp_debug('Atp_Sources: ' || 'We are in ODS, using msc_sources_v for sources.');

716:
717: ELSE
718: -- ODS, use msc_sources_v
719: IF PG_DEBUG in ('Y', 'C') THEN
720: msc_sch_wb.atp_debug('Atp_Sources: ' || 'We are in ODS, using msc_sources_v for sources.');
721: END IF;
722:
723: -- fix 1460753: make at for global sourcing rule
724: -- Bug 2585710. Rewriting the dynamic SQL into static form.

Line 749: FROM msc_sources_v s,

745: x_atp_sources.Preferred,
746: x_atp_sources.Lead_Time,
747: x_atp_sources.Ship_Method,
748: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
749: FROM msc_sources_v s,
750: msc_ship_set_temp msst
751: WHERE s.inventory_item_id = msst.inventory_item_id
752: AND s.organization_id = p_organization_id
753: AND s.sr_instance_id = p_instance_id

Line 853: -- we need to pick the sources from msc_sources_v instead of msc_item_sourcing

849: -- removing the wrokaround and look into the PDS data rather than ODS
850: -- data when the models are sourced.
851:
852: -- Modified on 11/06/2000 by ngoel. In case of multi-level, multi-org CTO
853: -- we need to pick the sources from msc_sources_v instead of msc_item_sourcing
854: -- since planning doesn't honor souring rules for models.
855:
856: -- Bug 1562754, use G_ASSEMBLY_LINE_ID instead of G_COMP_LINE_ID, to make sure that
857: -- in case of CTO, we try to get the BOM correctly from msc_bom_temp_table.-NGOEL 02/01/2001

Line 923: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in ods, using msc_sources_v');

919: ORDER BY rank asc, allocation_percent desc;
920: ELSE
921:
922: IF PG_DEBUG in ('Y', 'C') THEN
923: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in ods, using msc_sources_v');
924: END IF;
925: -- we are in ods
926: -- we are in ods or this is for multi-level, multi-org CTO, using msc_sources_v
927:

Line 926: -- we are in ods or this is for multi-level, multi-org CTO, using msc_sources_v

922: IF PG_DEBUG in ('Y', 'C') THEN
923: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in ods, using msc_sources_v');
924: END IF;
925: -- we are in ods
926: -- we are in ods or this is for multi-level, multi-org CTO, using msc_sources_v
927:
928: SELECT nvl(s.source_organization_id, p_organization_id), -- 1460753
929: nvl(s.source_org_instance_id, -1),
930: nvl(s.vendor_id, -1),

Line 950: FROM msc_sources_v s

946: x_atp_sources.Preferred,
947: x_atp_sources.Lead_Time,
948: x_atp_sources.Ship_Method,
949: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
950: FROM msc_sources_v s
951: WHERE s.inventory_item_id = l_inv_item_id
952: AND s.organization_id = p_organization_id
953: AND s.sr_instance_id = p_instance_id
954: AND s.assignment_set_id = p_assign_set_id