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_POST_PRO dependencies on MSC_ATP_PVT

Line 4386: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

4382: peg2.organization_id,
4383: peg2.sr_instance_id,
4384: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
4385: NVL(d1.demand_class, :def_num) demand_class,
4386: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
4387: 2, NVL(d2.PLANNED_SHIP_DATE,d2.USING_ASSEMBLY_DEMAND_DATE),
4388: NVL(d2.SCHEDULE_SHIP_DATE,d2.USING_ASSEMBLY_DEMAND_DATE))) demand_date,----plan by request date, promise date or schedule date
4389: -- cal.prior_date demand_date, -- 2859130
4390: -- cal.calendar_date demand_date,

Line 4560: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

4556: peg1.organization_id,
4557: peg1.sr_instance_id,
4558: NVL(s.demand_class, :def_num) demand_class,
4559: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
4560: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
4561: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
4562: NVL(d.SCHEDULE_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))) demand_date,--plan by request date, promise date or schedule date
4563: peg1.allocated_quantity,
4564: d.demand_id,

Line 4651: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

4647: peg1.sr_instance_id,
4648: :def_num demand_class,
4649: -- cal.prior_date, -- 2859130
4650: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
4651: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
4652: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
4653: NVL(d.SCHEDULE_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),--plan by request date, promise date or schedule date
4654: SUM(peg1.allocated_quantity),
4655: d.demand_id,

Line 4703: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

4699: peg1.organization_id,
4700: peg1.sr_instance_id,
4701: :def_num,
4702: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
4703: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
4704: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
4705: NVL(d.SCHEDULE_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),--plan by request date, promise date or schedule date
4706: -- 2859130 cal.prior_date,
4707: d.demand_id,

Line 5253: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

5249: peg2.organization_id,
5250: peg2.sr_instance_id,
5251: NVL(d1.demand_class, :def_num) demand_class,
5252: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
5253: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
5254: 2, NVL(d2.PLANNED_SHIP_DATE,d2.USING_ASSEMBLY_DEMAND_DATE),
5255: NVL(d2.SCHEDULE_SHIP_DATE,d2.USING_ASSEMBLY_DEMAND_DATE))) demand_date, --plan by request date, promise date or schedule date
5256: -- cal.prior_date demand_date,
5257: -- cal.calendar_date demand_date, -- 2859130

Line 5416: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

5412: peg1.organization_id,
5413: peg1.sr_instance_id,
5414: NVL(s.demand_class, :def_num) demand_class,
5415: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
5416: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
5417: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
5418: NVL(d.SCHEDULE_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))) demand_date,--plan by request date, promise date or schedule date
5419: peg1.allocated_quantity,
5420: d.demand_id,

Line 5502: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

5498: peg1.organization_id,
5499: peg1.sr_instance_id,
5500: :def_num demand_class,
5501: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
5502: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
5503: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
5504: NVL(d.SCHEDULE_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),--plan by request date, promise date or schedule date -- 2859130
5505: -- cal.prior_date,
5506: SUM(peg1.allocated_quantity),

Line 5555: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',

5551: peg1.organization_id,
5552: peg1.sr_instance_id,
5553: :def_num,
5554: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
5555: trunc(DECODE('||MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF||',
5556: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
5557: NVL(d.SCHEDULE_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),--plan by request date, promise date or schedule date
5558: --cal.prior_date,
5559: d.demand_id,

Line 6755: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

6751: -- for pds's repetitive schedule demand.
6752: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
6753: AND C.CALENDAR_DATE
6754: BETWEEN
6755: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6756: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6757: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6758: AND
6759: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,

Line 6760: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

6756: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6757: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6758: AND
6759: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
6760: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6761: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6762: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))--plan by request date, promise date or schedule date
6763: AND ((D.ORIGINATION_TYPE = 4 AND C.SEQ_NUM IS NOT NULL) OR
6764: (D.ORIGINATION_TYPE <> 4))

Line 6893: BETWEEN TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

6889: -- start date to end date), we need to make sure we only select work day
6890: -- for pds's repetitive schedule demand.
6891: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
6892: AND C.CALENDAR_DATE
6893: BETWEEN TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6894: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6895: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6896: AND TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
6897: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 6897: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

6893: BETWEEN TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6894: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6895: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6896: AND TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
6897: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6898: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6899: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))--plan by request date, promise date or schedule date
6900: AND ((D.ORIGINATION_TYPE = 4 AND C.SEQ_NUM IS NOT NULL) OR
6901: (D.ORIGINATION_TYPE <> 4))

Line 7039: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7035: I.organization_id,
7036: I.inventory_item_id,
7037: '@@@' demand_class,
7038: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
7039: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7040: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
7041: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) SD_DATE,
7042: --plan by request date, promise date or schedule date -- 2859130
7043: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY,

Line 7147: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7143: I.organization_id,
7144: I.inventory_item_id,
7145: '@@@' demand_class,
7146: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
7147: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7148: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
7149: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) SD_DATE,
7150: --plan by request date, promise date or schedule date -- 2859130
7151: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY,

Line 7376: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7372: I.organization_id,
7373: I.inventory_item_id,
7374: TRUNC(DECODE(D.RECORD_SOURCE,
7375: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
7376: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7377: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),
7378: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
7379: --plan by request date, promise date or schedule date
7380: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies

Line 7432: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7428: I.organization_id,
7429: I.inventory_item_id,
7430: TRUNC(DECODE(D.RECORD_SOURCE,
7431: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
7432: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7433: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),
7434: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
7435: --plan by request date, promise date or schedule date
7436: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies