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_EXPLODE_PHANTOM_RTGS dependencies on WIP_CONSTANTS

Line 170: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)

166: AND ROUT.assembly_item_id = p_phantom_item_id
167: AND ROUT.organization_id = p_org_id
168: AND ROUT.alternate_routing_designator is NULL
169: AND ROUT.common_routing_sequence_id = bos.routing_sequence_id
170: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
171: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
172: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
173: AND bos.operation_sequence_id = bor.operation_sequence_id
174: AND ROUT.organization_id = bd.organization_id

Line 171: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))

167: AND ROUT.organization_id = p_org_id
168: AND ROUT.alternate_routing_designator is NULL
169: AND ROUT.common_routing_sequence_id = bos.routing_sequence_id
170: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
171: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
172: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
173: AND bos.operation_sequence_id = bor.operation_sequence_id
174: AND ROUT.organization_id = bd.organization_id
175: AND bos.department_id = bd.department_id

Line 172: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)

168: AND ROUT.alternate_routing_designator is NULL
169: AND ROUT.common_routing_sequence_id = bos.routing_sequence_id
170: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
171: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
172: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
173: AND bos.operation_sequence_id = bor.operation_sequence_id
174: AND ROUT.organization_id = bd.organization_id
175: AND bos.department_id = bd.department_id
176: AND ROUT.organization_id = br.organization_id

Line 356: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)

352: AND BOR.assembly_item_id = p_phantom_item_id
353: AND BOR.organization_id = p_org_id
354: AND BOR.alternate_routing_designator is NULL
355: AND BOR.common_routing_sequence_id = bos.routing_sequence_id
356: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
357: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
358: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
359: AND bor.organization_id = bd.organization_id
360: AND bos.department_id = bd.department_id

Line 357: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))

353: AND BOR.organization_id = p_org_id
354: AND BOR.alternate_routing_designator is NULL
355: AND BOR.common_routing_sequence_id = bos.routing_sequence_id
356: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
357: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
358: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
359: AND bor.organization_id = bd.organization_id
360: AND bos.department_id = bd.department_id
361: AND bos.count_point_type in (1, 2) -- ovhd for autocharge operations

Line 358: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)

354: AND BOR.alternate_routing_designator is NULL
355: AND BOR.common_routing_sequence_id = bos.routing_sequence_id
356: AND BOS.effectivity_date <= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
357: AND NVL(BOS.disable_date, to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
358: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
359: AND bor.organization_id = bd.organization_id
360: AND bos.department_id = bd.department_id
361: AND bos.count_point_type in (1, 2) -- ovhd for autocharge operations
362: AND Nvl(bos.operation_type,1) = 1;

Line 528: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)

524: AND decode( NVL(wfs.Quantity_Completed, 0),
525: 0, 1,
526: 0 ) <> 0
527: AND BOS.effectivity_date <=
528: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
529: AND NVL(BOS.disable_date,
530: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
531: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
532: AND bor.organization_id = bd.organization_id

Line 530: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))

526: 0 ) <> 0
527: AND BOS.effectivity_date <=
528: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
529: AND NVL(BOS.disable_date,
530: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
531: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
532: AND bor.organization_id = bd.organization_id
533: AND bos.department_id = bd.department_id
534: AND bos.count_point_type in (1, 2) -- ovhd for autocharge operations

Line 531: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)

527: AND BOS.effectivity_date <=
528: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
529: AND NVL(BOS.disable_date,
530: to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT))
531: >= to_date(p_rtg_rev_date,WIP_CONSTANTS.DATETIME_FMT)
532: AND bor.organization_id = bd.organization_id
533: AND bos.department_id = bd.department_id
534: AND bos.count_point_type in (1, 2) -- ovhd for autocharge operations
535: AND Nvl(bos.operation_type, 1) = 1;

Line 653: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)

649: FROM WIP_OPERATION_RESOURCES
650: WHERE wip_entity_id = p_wip_entity_id
651: and organization_id = p_org_id
652: and NVL(repetitive_schedule_id, -1) =
653: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)
654: and operation_seq_num = p_op_seq_num;
655:
656: if x_max_resc_seq_num is null then
657: x_max_resc_seq_num := 0;

Line 671: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)

667: FROM WIP_OPERATION_RESOURCES
668: WHERE wip_entity_id = p_wip_entity_id
669: and organization_id = p_org_id
670: and NVL(repetitive_schedule_id, -1) =
671: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)
672: and resource_seq_num = x_max_resc_seq_num
673: and operation_seq_num = p_op_seq_num;
674:
675: exception

Line 698: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)

694: FROM WIP_OPERATIONS
695: WHERE wip_entity_id = p_wip_entity_id
696: AND organization_id = p_org_id
697: and NVL(repetitive_schedule_id, -1) =
698: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)
699: AND operation_seq_num = p_op_seq_num;
700:
701: /* --------------------------------------------------------- *
702: * GO through the cursor. Populate phantom resources *

Line 780: decode(cur_resc.basis_type, wip_constants.PER_LOT , cur_resc.usage_rate_or_amount,

776: cur_resc.basis_type,
777: /*Fixed Bug 5366856. Modified to consider yield factor for resources.
778: Lot based resources should be independent of Yield and QPA.
779: Item based Phantom resources should consider yield and QPA. */
780: decode(cur_resc.basis_type, wip_constants.PER_LOT , cur_resc.usage_rate_or_amount,
781: round((cur_resc.usage_rate_or_amount * nvl(x_comp_qty, 1)/nvl(x_yield_factor,1)),
782: wip_constants.max_displayed_precision)),/* Bug# 2115415 */
783: cur_resc.activity_id,
784: 2, /* non-scheduled */

Line 782: wip_constants.max_displayed_precision)),/* Bug# 2115415 */

778: Lot based resources should be independent of Yield and QPA.
779: Item based Phantom resources should consider yield and QPA. */
780: decode(cur_resc.basis_type, wip_constants.PER_LOT , cur_resc.usage_rate_or_amount,
781: round((cur_resc.usage_rate_or_amount * nvl(x_comp_qty, 1)/nvl(x_yield_factor,1)),
782: wip_constants.max_displayed_precision)),/* Bug# 2115415 */
783: cur_resc.activity_id,
784: 2, /* non-scheduled */
785: cur_resc.assigned_units,
786: cur_resc.autocharge_type,