APPS.WIP_FLOW_CHARGE_UTILITIES dependencies on WIP_FLOW_UTILITIES

Line 193: AND wip_flow_utilities.event_to_lineop_seq_num(

189: AND bor.usage_rate_or_amount <> 0
190: AND (bos.count_point_type in (1, 2)
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,

Line 210: AND wip_flow_utilities.same_or_prior_lineop_safe(bos.routing_sequence_id,

206: 0),
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

Line 422: AND wip_flow_utilities.event_to_lineop_seq_num(

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
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

Line 427: AND wip_flow_utilities.same_or_prior_lineop_safe(bos.routing_sequence_id,

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),
429: bos.operation_seq_num,
430: Nvl(mmtt.operation_seq_num,-1)) = 1; -- CFM Scrap
431: return 1;

Line 605: AND wip_flow_utilities.event_to_lineop_seq_num(

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
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

Line 613: AND wip_flow_utilities.same_or_prior_lineop_safe(bos.routing_sequence_id,

609: AND Nvl(bos.operation_type,1) = 1
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: