[Home] [Help]
412: 1),
413: 0)
414: FROM
415: wip_operation_resources w2,
416: cst_comp_snapshot cocd
417: WHERE
418: W1.WIP_ENTITY_ID = W2.WIP_ENTITY_ID AND
419: W1.OPERATION_SEQ_NUM = W2.OPERATION_SEQ_NUM AND
420: W1.RESOURCE_SEQ_NUM = W2.RESOURCE_SEQ_NUM AND
500: 1),
501: 0)
502: FROM
503: wip_operation_overheads W2,
504: cst_comp_snapshot COCD
505: WHERE
506: w1.wip_entity_id = w2.wip_entity_id AND
507: w1.operation_seq_num = w2.operation_seq_num AND
508: w1.resource_seq_num = w2.resource_seq_num AND
736: WRO.relieved_matl_scrap_quantity,
737: decode( nvl( CCS.prior_scrap_quantity, 0 ), 0, 1,
738: i_txn_qty / CCS.prior_scrap_quantity ) component_ratio
739: from wip_requirement_operations WRO,
740: cst_comp_snapshot CCS
741: where WRO.wip_entity_id = i_wip_entity_id and
742: WRO.operation_seq_num <= i_op_seq_num and
743: WRO.wip_supply_type not in (4,5,6) and
744: WRO.quantity_per_assembly <> 0 and
840: wro_rec.quantity_per_assembly;
841:
842:
843: /* reduce the relieved_matl_scrap_quantity
844: by percentage using cst_comp_snapshot */
845: l_txn_qty_remaining := nvl(wro_rec.relieved_matl_scrap_quantity, 0) *
846: nvl(wro_rec.component_ratio, 0);
847:
848:
1056: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,
1057: PRIOR_SCRAP_QUANTITY))
1058: FROM
1059: WIP_OPERATION_RESOURCES W2,
1060: cst_comp_snapshot COCD
1061: WHERE
1062: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1063: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1064: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND
1097: PRIOR_SCRAP_QUANTITY,-1,
1098: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
1099: FROM
1100: wip_operation_overheads W2,
1101: cst_comp_snapshot COCD
1102: WHERE
1103: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1104: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1105: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND