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.WIP_FLOW_CHARGE_UTILITIES dependencies on WIP_CONSTANTS

Line 174: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

170: AND MMTT.common_routing_seq_id = bos.routing_sequence_id
171: -- for implement ECO we only explode those operations with implementation date
172: AND BOS.implementation_date is not null
173: AND BOS.effectivity_date <=
174: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
175: AND NVL(BOS.disable_date,
176: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
177: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
178: AND bos.operation_sequence_id = bor.operation_sequence_id

Line 176: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))

172: AND BOS.implementation_date is not null
173: AND BOS.effectivity_date <=
174: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
175: AND NVL(BOS.disable_date,
176: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
177: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
178: AND bos.operation_sequence_id = bor.operation_sequence_id
179: AND wfs.organization_id = bd.organization_id
180: AND bos.department_id = bd.department_id

Line 177: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

173: AND BOS.effectivity_date <=
174: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
175: AND NVL(BOS.disable_date,
176: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
177: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
178: AND bos.operation_sequence_id = bor.operation_sequence_id
179: AND wfs.organization_id = bd.organization_id
180: AND bos.department_id = bd.department_id
181: AND wfs.organization_id = br.organization_id

Line 195: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),

191: OR (mmtt.transaction_action_id = 30
192: AND Nvl(mmtt.operation_seq_num,-1) <> -1
193: AND wip_flow_utilities.event_to_lineop_seq_num(
194: bos.routing_sequence_id,
195: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),
196: bos.operation_seq_num) = mmtt.operation_seq_num)) --CFM Scrap. Resources are charged at the scrap line op even if the events are non-autocharge operations.
197: AND DECODE (BOR.BASIS_TYPE,
198: 1, MMTT.TRANSACTION_QUANTITY,
199: 2, DECODE(wfs.QUANTITY_COMPLETED,

Line 211: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),

207: 0) <> 30 -- Lot based resources are not charged for scheduled cfm scrap
208: AND bor.activity_id = ca.activity_id (+)
209: AND Nvl(bos.operation_type,1) = 1
210: AND wip_flow_utilities.same_or_prior_lineop_safe(bos.routing_sequence_id,
211: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),
212: bos.operation_seq_num,
213: Nvl(mmtt.operation_seq_num,-1)) = 1 -- CFM Scrap
214: GROUP BY
215: BOS.OPERATION_SEQ_NUM,

Line 413: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

409: AND MMTT.common_routing_seq_id = bos.routing_sequence_id
410: -- for implement ECO we only explode those operations with implementation date
411: AND BOS.implementation_date is not null
412: AND BOS.effectivity_date <=
413: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
414: AND NVL(BOS.disable_date,
415: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
416: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
417: AND wfs.organization_id = bd.organization_id

Line 415: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))

411: AND BOS.implementation_date is not null
412: AND BOS.effectivity_date <=
413: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
414: AND NVL(BOS.disable_date,
415: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
416: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
417: AND wfs.organization_id = bd.organization_id
418: AND bos.department_id = bd.department_id
419: AND (bos.count_point_type in (1, 2) -- ovhd for autocharge operations

Line 416: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

412: AND BOS.effectivity_date <=
413: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
414: AND NVL(BOS.disable_date,
415: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
416: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
417: AND wfs.organization_id = bd.organization_id
418: AND bos.department_id = bd.department_id
419: AND (bos.count_point_type in (1, 2) -- ovhd for autocharge operations
420: OR (mmtt.transaction_action_id = 30

Line 424: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),

420: OR (mmtt.transaction_action_id = 30
421: AND Nvl(mmtt.operation_seq_num,-1) <> -1
422: AND wip_flow_utilities.event_to_lineop_seq_num(
423: bos.routing_sequence_id,
424: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),
425: bos.operation_seq_num) = mmtt.operation_seq_num)) --CFM Scrap. Overheads are charged at the scrap line op even if the events are non-autocharge operations.
426: AND Nvl(bos.operation_type,1) = 1
427: AND wip_flow_utilities.same_or_prior_lineop_safe(bos.routing_sequence_id,
428: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),

Line 428: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),

424: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),
425: bos.operation_seq_num) = mmtt.operation_seq_num)) --CFM Scrap. Overheads are charged at the scrap line op even if the events are non-autocharge operations.
426: AND Nvl(bos.operation_type,1) = 1
427: AND wip_flow_utilities.same_or_prior_lineop_safe(bos.routing_sequence_id,
428: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),
429: bos.operation_seq_num,
430: Nvl(mmtt.operation_seq_num,-1)) = 1; -- CFM Scrap
431: return 1;
432:

Line 596: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

592: 0 ) <> 0
593: -- for implement ECO we only explode those operations with implementation date
594: AND BOS.implementation_date is not null
595: AND BOS.effectivity_date <=
596: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
597: AND NVL(BOS.disable_date,
598: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
599: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
600: AND wfs.organization_id = bd.organization_id

Line 598: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))

594: AND BOS.implementation_date is not null
595: AND BOS.effectivity_date <=
596: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
597: AND NVL(BOS.disable_date,
598: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
599: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
600: AND wfs.organization_id = bd.organization_id
601: AND bos.department_id = bd.department_id
602: AND (bos.count_point_type in (1, 2) -- ovhd for autocharge operations

Line 599: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

595: AND BOS.effectivity_date <=
596: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
597: AND NVL(BOS.disable_date,
598: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
599: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
600: AND wfs.organization_id = bd.organization_id
601: AND bos.department_id = bd.department_id
602: AND (bos.count_point_type in (1, 2) -- ovhd for autocharge operations
603: OR (mmtt.transaction_action_id = 30

Line 607: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),

603: OR (mmtt.transaction_action_id = 30
604: AND Nvl(mmtt.operation_seq_num,-1) <> -1
605: AND wip_flow_utilities.event_to_lineop_seq_num(
606: bos.routing_sequence_id,
607: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),
608: bos.operation_seq_num) = mmtt.operation_seq_num)) --CFM Scrap. Overheads are charged at the scrap line op even if the events are non-autocharge operations.
609: AND Nvl(bos.operation_type,1) = 1
610: AND Decode(WFS.SCHEDULED_FLAG,
611: 1,MMTT.TRANSACTION_ACTION_ID,

Line 614: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),

610: AND Decode(WFS.SCHEDULED_FLAG,
611: 1,MMTT.TRANSACTION_ACTION_ID,
612: 0) <> 30 -- Lot based ovhds are not charged for scheduled cfm scrap
613: AND wip_flow_utilities.same_or_prior_lineop_safe(bos.routing_sequence_id,
614: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT),
615: bos.operation_seq_num,
616: Nvl(mmtt.operation_seq_num,-1)) = 1; -- CFM Scrap
617:
618: return 1;

Line 686: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

682: AND bor.common_routing_sequence_id = bos.routing_sequence_id
683: -- for implement ECO we only explode those operations with implementation date
684: AND BOS.implementation_date is not null
685: AND bos.effectivity_date <=
686: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
687: AND NVL(bos.disable_date,
688: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
689: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
690: AND bos.operation_seq_num = mmtt.operation_seq_num*(-1)

Line 688: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))

684: AND BOS.implementation_date is not null
685: AND bos.effectivity_date <=
686: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
687: AND NVL(bos.disable_date,
688: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
689: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
690: AND bos.operation_seq_num = mmtt.operation_seq_num*(-1)
691: AND Nvl(bos.operation_type,1) = 1
692: AND bos.count_point_type in (1, 2)

Line 689: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

685: AND bos.effectivity_date <=
686: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
687: AND NVL(bos.disable_date,
688: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
689: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
690: AND bos.operation_seq_num = mmtt.operation_seq_num*(-1)
691: AND Nvl(bos.operation_type,1) = 1
692: AND bos.count_point_type in (1, 2)
693: /* Start of fix for bug 2743096: To bring in records from mmtt where

Line 725: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

721: AND bor.common_routing_sequence_id = bos.routing_sequence_id
722: -- for implement ECO we only explode those operations with implementation date
723: AND BOS.implementation_date is not null
724: AND bos.effectivity_date <=
725: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
726: AND NVL(bos.disable_date,
727: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
728: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
729: AND mmtt.operation_seq_num = -1 /* for phantoms attached to op seq 1 */

Line 727: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))

723: AND BOS.implementation_date is not null
724: AND bos.effectivity_date <=
725: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
726: AND NVL(bos.disable_date,
727: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
728: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
729: AND mmtt.operation_seq_num = -1 /* for phantoms attached to op seq 1 */
730: AND Nvl(bos.operation_type,1) = 1
731: AND bos.count_point_type in (1, 2);

Line 728: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)

724: AND bos.effectivity_date <=
725: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
726: AND NVL(bos.disable_date,
727: to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT))
728: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DT_NOSEC_FMT)
729: AND mmtt.operation_seq_num = -1 /* for phantoms attached to op seq 1 */
730: AND Nvl(bos.operation_type,1) = 1
731: AND bos.count_point_type in (1, 2);
732: /* End of fix for bug 2743096 */

Line 781: IF (wip_globals.USE_PHANTOM_ROUTINGS(x_org_id) = WIP_CONSTANTS.YES) THEN

777: FROM mtl_material_transactions_temp
778: WHERE transaction_header_id = p_header_id
779: AND rownum = 1;
780:
781: IF (wip_globals.USE_PHANTOM_ROUTINGS(x_org_id) = WIP_CONSTANTS.YES) THEN
782: FOR Phan_Rec IN phantoms(p_header_id) LOOP
783: x_success := 0;
784:
785: x_success := WIP_EXPLODE_PHANTOM_RTGS.charge_flow_resource_ovhd(