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 719: -- ODS, use msc_sources_v

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

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

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

Line 750: FROM msc_sources_v s,

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

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

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

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

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

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

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

Line 951: FROM msc_sources_v s

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