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_ITEM_SOURCING

Line 647: -- pds , use msc_item_sourcing table

643:
644: -- the cursor is different if it is ods or pds
645: --bug 3495773: Add nvl condition
646: IF nvl(p_plan_id, -1) <> -1 THEN
647: -- pds , use msc_item_sourcing table
648: IF PG_DEBUG in ('Y', 'C') THEN
649: msc_sch_wb.atp_debug('Atp_Sources: ' || 'inside ship set, p_plan_id <> -1');
650: END IF;
651:

Line 690: msc_item_sourcing s,

686: x_atp_sources.Lead_Time,
687: x_atp_sources.Ship_Method,
688: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
689: FROM
690: msc_item_sourcing s,
691: msc_ship_set_temp msst,
692: msc_trading_partner_sites mtps -- For supplier intransit LT project
693: WHERE
694: s.inventory_item_id = msst.inventory_item_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 863: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in pds, using msc_item_sourcing');

859: -- IF p_plan_id <> -1 AND l_cto_bom = 0 THEN
860: --bug 3495773: Add nvl condition
861: IF nvl(p_plan_id, -1) <> -1 THEN
862: IF PG_DEBUG in ('Y', 'C') THEN
863: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in pds, using msc_item_sourcing');
864: END IF;
865: -- we are in pds, using msc_item_sourcing
866:
867: -- Fix for bug 1454524, no need to join based on assignment set as only 1 assignment

Line 865: -- we are in pds, using msc_item_sourcing

861: IF nvl(p_plan_id, -1) <> -1 THEN
862: IF PG_DEBUG in ('Y', 'C') THEN
863: msc_sch_wb.atp_debug('Atp_Sources: ' || 'we are in pds, using msc_item_sourcing');
864: END IF;
865: -- we are in pds, using msc_item_sourcing
866:
867: -- Fix for bug 1454524, no need to join based on assignment set as only 1 assignment
868: -- set is supported for a plan.
869: SELECT nvl(s.source_organization_id, -1),

Line 904: FROM msc_item_sourcing s,

900: x_atp_sources.Preferred,
901: x_atp_sources.Lead_Time,
902: x_atp_sources.Ship_Method,
903: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
904: FROM msc_item_sourcing s,
905: msc_trading_partner_sites mtps -- For supplier intransit LT project
906: WHERE s.inventory_item_id = l_inv_item_id
907: AND s.organization_id = p_organization_id
908: AND s.sr_instance_id = p_instance_id