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 648: -- pds , use msc_item_sourcing table

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

Line 691: msc_item_sourcing s,

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

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

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

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

Line 905: FROM msc_item_sourcing s,

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