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.

[Home] [Help]

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 6726: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

6722: -- for pds's repetitive schedule demand.
6723: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
6724: AND C.CALENDAR_DATE
6725: BETWEEN
6726: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6727: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6728: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6729: AND
6730: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,

Line 6731: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

6727: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6728: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6729: AND
6730: TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
6731: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6732: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6733: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))--plan by request date, promise date or schedule date
6734: AND ((D.ORIGINATION_TYPE = 4 AND C.SEQ_NUM IS NOT NULL) OR
6735: (D.ORIGINATION_TYPE <> 4))

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

6860: -- start date to end date), we need to make sure we only select work day
6861: -- for pds's repetitive schedule demand.
6862: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
6863: AND C.CALENDAR_DATE
6864: BETWEEN TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6865: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6866: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6867: AND TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
6868: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

Line 6868: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

6864: BETWEEN TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6865: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6866: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))
6867: AND TRUNC(NVL(D.ASSEMBLY_DEMAND_COMP_DATE,
6868: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
6869: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
6870: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))))--plan by request date, promise date or schedule date
6871: AND ((D.ORIGINATION_TYPE = 4 AND C.SEQ_NUM IS NOT NULL) OR
6872: (D.ORIGINATION_TYPE <> 4))

Line 7010: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7006: I.organization_id,
7007: I.inventory_item_id,
7008: '@@@' demand_class,
7009: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
7010: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7011: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
7012: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) SD_DATE,
7013: --plan by request date, promise date or schedule date -- 2859130
7014: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY,

Line 7118: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7114: I.organization_id,
7115: I.inventory_item_id,
7116: '@@@' demand_class,
7117: -- Bug 3574164 DMD_SATISFIED_DATE IS CHANGED TO PLANNED_SHIP_DATE.
7118: TRUNC(DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7119: 2, NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE),
7120: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE))) SD_DATE,
7121: --plan by request date, promise date or schedule date -- 2859130
7122: -1* D.USING_REQUIREMENT_QUANTITY SD_QTY,

Line 7347: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7343: I.organization_id,
7344: I.inventory_item_id,
7345: TRUNC(DECODE(D.RECORD_SOURCE,
7346: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
7347: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7348: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),
7349: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
7350: --plan by request date, promise date or schedule date
7351: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies

Line 7403: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,

7399: I.organization_id,
7400: I.inventory_item_id,
7401: TRUNC(DECODE(D.RECORD_SOURCE,
7402: 2, NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE),
7403: DECODE(MSC_ATP_PVT.G_HP_DEMAND_BUCKETING_PREF,
7404: 2, NVL(D.IMPLEMENT_SHIP_DATE,NVL(D.FIRM_DATE,NVL(d.PLANNED_SHIP_DATE,d.USING_ASSEMBLY_DEMAND_DATE))),
7405: NVL(D.SCHEDULE_SHIP_DATE,D.USING_ASSEMBLY_DEMAND_DATE)))) SD_DATE,
7406: --plan by request date, promise date or schedule date
7407: decode(D.USING_REQUIREMENT_QUANTITY, -- Consider unscheduled orders as dummy supplies