[Home] [Help]
3429: phantom_flag,
3430: usage_rate_or_amount,
3431: basis_type,
3432: autocharge_type,
3433: standard_rate_flag,
3434: transaction_quantity,
3435: transaction_uom,
3436: primary_quantity,
3437: primary_uom,
3486: wor.phantom_flag,
3487: wor.usage_rate_or_amount,
3488: wor.basis_type,
3489: wor.autocharge_type,
3490: wor.standard_rate_flag,
3491: wor.usage_rate_or_amount * NVL(wmti.primary_quantity *
3492: DECODE(
3493: SIGN(wmti.to_operation_seq_num - wmti.fm_operation_seq_num),
3494: 0,DECODE(SIGN(wmti.fm_intraoperation_step_type -
3646: phantom_flag,
3647: usage_rate_or_amount,
3648: basis_type,
3649: autocharge_type,
3650: standard_rate_flag,
3651: transaction_quantity,
3652: transaction_uom,
3653: primary_quantity,
3654: primary_uom,
3700: MAX(wor.phantom_flag),
3701: wor.usage_rate_or_amount,
3702: MAX(wor.basis_type),
3703: MAX(wor.autocharge_type),
3704: wor.standard_rate_flag,
3705: SUM(wor.usage_rate_or_amount * NVL(wma.primary_quantity *
3706: DECODE(
3707: SIGN(wmti.to_operation_seq_num-wmti.fm_operation_seq_num),
3708: 0, DECODE(SIGN(wmti.fm_intraoperation_step_type -
3807: wop.operation_seq_num,
3808: wor.resource_seq_num,
3809: wor.resource_id,
3810: wor.activity_id,
3811: wor.standard_rate_flag,
3812: wor.usage_rate_or_amount,
3813: wmti.transaction_id;
3814:
3815: -- IF debug message level = 2, write statement below to log file
3871: phantom_flag,
3872: usage_rate_or_amount,
3873: basis_type,
3874: autocharge_type,
3875: standard_rate_flag,
3876: transaction_quantity,
3877: transaction_uom,
3878: primary_quantity,
3879: primary_uom,
3928: MAX(wor.phantom_flag),
3929: MAX(wor.usage_rate_or_amount),
3930: MAX(wor.basis_type),
3931: MAX(wor.autocharge_type),
3932: MAX(wor.standard_rate_flag),
3933: MAX(wor.usage_rate_or_amount) * -- transaction_quantity
3934: DECODE(SIGN(MAX(wop.quantity_completed) +
3935: NVL(SUM(wmti.primary_quantity *
3936: DECODE(SIGN(wmti.to_operation_seq_num -
4120: phantom_flag,
4121: usage_rate_or_amount,
4122: basis_type,
4123: autocharge_type,
4124: standard_rate_flag,
4125: transaction_quantity,
4126: transaction_uom,
4127: primary_quantity,
4128: primary_uom,
4175: MAX(wor.phantom_flag),
4176: wor.usage_rate_or_amount,
4177: MAX(wor.basis_type),
4178: MAX(wor.autocharge_type),
4179: wor.standard_rate_flag,
4180: 1, -- transaction_quantity
4181: MAX(wor.uom_code), -- transaction_uom
4182: 1, -- primary_quantity
4183: MAX(wor.uom_code), -- primary_uom
4260: wop.operation_seq_num,
4261: wor.resource_seq_num,
4262: wor.resource_id,
4263: wor.activity_id,
4264: wor.standard_rate_flag,
4265: wor.usage_rate_or_amount
4266: HAVING 0 <>
4267: DECODE(SIGN(MAX(wop.quantity_completed) + NVL(SUM(
4268: wma.primary_quantity *
4426: AND wci.wip_entity_id = wor.wip_entity_id
4427: AND wci.operation_seq_num = wor.operation_seq_num
4428: AND wci.resource_seq_num = wor.resource_seq_num
4429: AND wci.resource_id = wor.resource_id
4430: AND wci.standard_rate_flag = wor.standard_rate_flag
4431: AND wci.usage_rate_or_amount = wor.usage_rate_or_amount
4432: AND NVL(wci.activity_id, -1) = NVL(wor.activity_id, -1)
4433: AND wor.autocharge_type = WIP_CONSTANTS.WIP_MOVE
4434: AND wor.basis_type = WIP_CONSTANTS.PER_LOT
4579: AND wor.operation_seq_num = wcti.operation_seq_num
4580: AND wor.resource_seq_num = wcti.resource_seq_num
4581: AND wor.resource_id = wcti.resource_id
4582: AND NVL(wor.activity_id, -1) = NVL(wcti.activity_id, -1)
4583: AND wor.standard_rate_flag = wcti.standard_rate_flag
4584: AND wor.usage_rate_or_amount = wcti.usage_rate_or_amount;
4585:
4586: -- IF debug message level = 2, write statement below to log file
4587: IF (l_logLevel <= wip_constants.full_logging) THEN
4719: phantom_flag,
4720: usage_rate_or_amount,
4721: basis_type,
4722: autocharge_type,
4723: standard_rate_flag,
4724: transaction_quantity,
4725: transaction_uom,
4726: primary_quantity,
4727: primary_uom,
4775: MAX(wor.phantom_flag),
4776: NULL, -- usage_rate_or_amount
4777: WIP_CONSTANTS.PER_ITEM, -- basis_type
4778: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
4779: NULL, -- standard_rate_flag
4780: MAX(NVL(DECODE(wor.phantom_flag, 1, wro.quantity_per_assembly, 1)
4781: * wmti.primary_quantity *
4782: DECODE(SIGN(wmti.to_operation_seq_num -
4783: wmti.fm_operation_seq_num),
4947: phantom_flag,
4948: usage_rate_or_amount,
4949: basis_type,
4950: autocharge_type,
4951: standard_rate_flag,
4952: transaction_quantity,
4953: transaction_uom,
4954: primary_quantity,
4955: primary_uom,
5001: max(wor.phantom_flag),
5002: NULL, -- usage_rate_or_amount
5003: WIP_CONSTANTS.PER_ITEM, -- basis_type
5004: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
5005: NULL, -- standard_rate_flag
5006: SUM(NVL(wma.primary_quantity *
5007: DECODE(SIGN(wmti.to_operation_seq_num -
5008: wmti.fm_operation_seq_num),
5009: 0,DECODE(SIGN(wmti.fm_intraoperation_step_type -
5164: phantom_flag,
5165: usage_rate_or_amount,
5166: basis_type,
5167: autocharge_type,
5168: standard_rate_flag,
5169: transaction_quantity,
5170: transaction_uom,
5171: primary_quantity,
5172: primary_uom,
5220: MAX(wor.phantom_flag),
5221: NULL, -- usage_rate_or_amount
5222: WIP_CONSTANTS.PER_LOT, -- basis_type
5223: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
5224: NULL, -- standard_rate_flag
5225: DECODE(SIGN(MAX(wop.quantity_completed) +
5226: /* Fixed bug 3740010 change from "NVL(SUM(wmti.primary_quantity"
5227: * to "NVL(MAX(wmti.primary_quantity" because there may be
5228: * multiple resources per operation.
5421: phantom_flag,
5422: usage_rate_or_amount,
5423: basis_type,
5424: autocharge_type,
5425: standard_rate_flag,
5426: transaction_quantity,
5427: transaction_uom,
5428: primary_quantity,
5429: primary_uom,
5476: MAX(wor.phantom_flag),
5477: NULL, -- usage_rate_or_amount
5478: WIP_CONSTANTS.PER_LOT, -- basis_type
5479: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
5480: NULL, -- standard_rate_flag
5481: 1, -- transaction_quantity
5482: MAX(wmti.primary_uom), -- transaction_uom
5483: 1, -- primary_quantity
5484: MAX(wmti.primary_uom), -- primary_uom