[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
501: 1),
502: 0)
503: FROM
504: wip_operation_overheads W2,
505: cst_comp_snapshot COCD
506: WHERE
507: w1.wip_entity_id = w2.wip_entity_id AND
508: w1.operation_seq_num = w2.operation_seq_num AND
509: w1.resource_seq_num = w2.resource_seq_num AND
738: WRO.relieved_matl_scrap_quantity,
739: decode( nvl( CCS.prior_scrap_quantity, 0 ), 0, 1,
740: i_txn_qty / CCS.prior_scrap_quantity ) component_ratio
741: from wip_requirement_operations WRO,
742: cst_comp_snapshot CCS
743: where WRO.wip_entity_id = i_wip_entity_id and
744: WRO.operation_seq_num <= i_op_seq_num and
745: WRO.wip_supply_type not in (4,5,6) and
746: WRO.quantity_per_assembly <> 0 and
843: wro_rec.quantity_per_assembly;
844:
845:
846: /* reduce the relieved_matl_scrap_quantity
847: by percentage using cst_comp_snapshot */
848: l_txn_qty_remaining := nvl(wro_rec.relieved_matl_scrap_quantity, 0) *
849: nvl(wro_rec.component_ratio, 0);
850:
851:
1059: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,
1060: PRIOR_SCRAP_QUANTITY))
1061: FROM
1062: WIP_OPERATION_RESOURCES W2,
1063: cst_comp_snapshot COCD
1064: WHERE
1065: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1066: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1067: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND
1101: PRIOR_SCRAP_QUANTITY,-1,
1102: i_txn_qty/decode(PRIOR_SCRAP_QUANTITY,NULL,1,0,1,PRIOR_SCRAP_QUANTITY))
1103: FROM
1104: wip_operation_overheads W2,
1105: cst_comp_snapshot COCD
1106: WHERE
1107: W2.WIP_ENTITY_ID = W1.WIP_ENTITY_ID AND
1108: W2.ORGANIZATION_ID = W1.ORGANIZATION_ID AND
1109: W2.OPERATION_SEQ_NUM = W1.OPERATION_SEQ_NUM AND