[Home] [Help]
3300: phantom_flag,
3301: usage_rate_or_amount,
3302: basis_type,
3303: autocharge_type,
3304: standard_rate_flag,
3305: transaction_quantity,
3306: transaction_uom,
3307: primary_quantity,
3308: primary_uom,
3357: wor.phantom_flag,
3358: wor.usage_rate_or_amount,
3359: wor.basis_type,
3360: wor.autocharge_type,
3361: wor.standard_rate_flag,
3362: wor.usage_rate_or_amount * NVL(wmti.primary_quantity *
3363: DECODE(
3364: SIGN(wmti.to_operation_seq_num - wmti.fm_operation_seq_num),
3365: 0,DECODE(SIGN(wmti.fm_intraoperation_step_type -
3517: phantom_flag,
3518: usage_rate_or_amount,
3519: basis_type,
3520: autocharge_type,
3521: standard_rate_flag,
3522: transaction_quantity,
3523: transaction_uom,
3524: primary_quantity,
3525: primary_uom,
3571: MAX(wor.phantom_flag),
3572: wor.usage_rate_or_amount,
3573: MAX(wor.basis_type),
3574: MAX(wor.autocharge_type),
3575: wor.standard_rate_flag,
3576: SUM(wor.usage_rate_or_amount * NVL(wma.primary_quantity *
3577: DECODE(
3578: SIGN(wmti.to_operation_seq_num-wmti.fm_operation_seq_num),
3579: 0, DECODE(SIGN(wmti.fm_intraoperation_step_type -
3678: wop.operation_seq_num,
3679: wor.resource_seq_num,
3680: wor.resource_id,
3681: wor.activity_id,
3682: wor.standard_rate_flag,
3683: wor.usage_rate_or_amount,
3684: wmti.transaction_id;
3685:
3686: -- IF debug message level = 2, write statement below to log file
3742: phantom_flag,
3743: usage_rate_or_amount,
3744: basis_type,
3745: autocharge_type,
3746: standard_rate_flag,
3747: transaction_quantity,
3748: transaction_uom,
3749: primary_quantity,
3750: primary_uom,
3799: MAX(wor.phantom_flag),
3800: MAX(wor.usage_rate_or_amount),
3801: MAX(wor.basis_type),
3802: MAX(wor.autocharge_type),
3803: MAX(wor.standard_rate_flag),
3804: MAX(wor.usage_rate_or_amount) * -- transaction_quantity
3805: DECODE(SIGN(MAX(wop.quantity_completed) +
3806: NVL(SUM(wmti.primary_quantity *
3807: DECODE(SIGN(wmti.to_operation_seq_num -
3991: phantom_flag,
3992: usage_rate_or_amount,
3993: basis_type,
3994: autocharge_type,
3995: standard_rate_flag,
3996: transaction_quantity,
3997: transaction_uom,
3998: primary_quantity,
3999: primary_uom,
4046: MAX(wor.phantom_flag),
4047: wor.usage_rate_or_amount,
4048: MAX(wor.basis_type),
4049: MAX(wor.autocharge_type),
4050: wor.standard_rate_flag,
4051: 1, -- transaction_quantity
4052: MAX(wor.uom_code), -- transaction_uom
4053: 1, -- primary_quantity
4054: MAX(wor.uom_code), -- primary_uom
4131: wop.operation_seq_num,
4132: wor.resource_seq_num,
4133: wor.resource_id,
4134: wor.activity_id,
4135: wor.standard_rate_flag,
4136: wor.usage_rate_or_amount
4137: HAVING 0 <>
4138: DECODE(SIGN(MAX(wop.quantity_completed) + NVL(SUM(
4139: wma.primary_quantity *
4297: AND wci.wip_entity_id = wor.wip_entity_id
4298: AND wci.operation_seq_num = wor.operation_seq_num
4299: AND wci.resource_seq_num = wor.resource_seq_num
4300: AND wci.resource_id = wor.resource_id
4301: AND wci.standard_rate_flag = wor.standard_rate_flag
4302: AND wci.usage_rate_or_amount = wor.usage_rate_or_amount
4303: AND NVL(wci.activity_id, -1) = NVL(wor.activity_id, -1)
4304: AND wor.autocharge_type = WIP_CONSTANTS.WIP_MOVE
4305: AND wor.basis_type = WIP_CONSTANTS.PER_LOT
4450: AND wor.operation_seq_num = wcti.operation_seq_num
4451: AND wor.resource_seq_num = wcti.resource_seq_num
4452: AND wor.resource_id = wcti.resource_id
4453: AND NVL(wor.activity_id, -1) = NVL(wcti.activity_id, -1)
4454: AND wor.standard_rate_flag = wcti.standard_rate_flag
4455: AND wor.usage_rate_or_amount = wcti.usage_rate_or_amount;
4456:
4457: -- IF debug message level = 2, write statement below to log file
4458: IF (l_logLevel <= wip_constants.full_logging) THEN
4590: phantom_flag,
4591: usage_rate_or_amount,
4592: basis_type,
4593: autocharge_type,
4594: standard_rate_flag,
4595: transaction_quantity,
4596: transaction_uom,
4597: primary_quantity,
4598: primary_uom,
4646: MAX(wor.phantom_flag),
4647: NULL, -- usage_rate_or_amount
4648: WIP_CONSTANTS.PER_ITEM, -- basis_type
4649: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
4650: NULL, -- standard_rate_flag
4651: MAX(NVL(DECODE(wor.phantom_flag, 1, wro.quantity_per_assembly, 1)
4652: * wmti.primary_quantity *
4653: DECODE(SIGN(wmti.to_operation_seq_num -
4654: wmti.fm_operation_seq_num),
4818: phantom_flag,
4819: usage_rate_or_amount,
4820: basis_type,
4821: autocharge_type,
4822: standard_rate_flag,
4823: transaction_quantity,
4824: transaction_uom,
4825: primary_quantity,
4826: primary_uom,
4872: max(wor.phantom_flag),
4873: NULL, -- usage_rate_or_amount
4874: WIP_CONSTANTS.PER_ITEM, -- basis_type
4875: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
4876: NULL, -- standard_rate_flag
4877: SUM(NVL(wma.primary_quantity *
4878: DECODE(SIGN(wmti.to_operation_seq_num -
4879: wmti.fm_operation_seq_num),
4880: 0,DECODE(SIGN(wmti.fm_intraoperation_step_type -
5035: phantom_flag,
5036: usage_rate_or_amount,
5037: basis_type,
5038: autocharge_type,
5039: standard_rate_flag,
5040: transaction_quantity,
5041: transaction_uom,
5042: primary_quantity,
5043: primary_uom,
5091: MAX(wor.phantom_flag),
5092: NULL, -- usage_rate_or_amount
5093: WIP_CONSTANTS.PER_LOT, -- basis_type
5094: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
5095: NULL, -- standard_rate_flag
5096: DECODE(SIGN(MAX(wop.quantity_completed) +
5097: /* Fixed bug 3740010 change from "NVL(SUM(wmti.primary_quantity"
5098: * to "NVL(MAX(wmti.primary_quantity" because there may be
5099: * multiple resources per operation.
5292: phantom_flag,
5293: usage_rate_or_amount,
5294: basis_type,
5295: autocharge_type,
5296: standard_rate_flag,
5297: transaction_quantity,
5298: transaction_uom,
5299: primary_quantity,
5300: primary_uom,
5347: MAX(wor.phantom_flag),
5348: NULL, -- usage_rate_or_amount
5349: WIP_CONSTANTS.PER_LOT, -- basis_type
5350: WIP_CONSTANTS.WIP_MOVE, -- autocharge_type
5351: NULL, -- standard_rate_flag
5352: 1, -- transaction_quantity
5353: MAX(wmti.primary_uom), -- transaction_uom
5354: 1, -- primary_quantity
5355: MAX(wmti.primary_uom), -- primary_uom