[Home] [Help]
139: 1) OPERATION_YIELD,
140: NVL(WO.DEPARTMENT_ID, 0) DEPARTMENT_ID,
141: WO.DISABLE_DATE DISABLE_DATE
142: FROM WIP_OPERATION_YIELDS WOY,
143: WIP_OPERATIONS WO
144: WHERE WOY.WIP_ENTITY_ID = p_entity_id
145: AND WOY.OPERATION_SEQ_NUM >= p_starting_opseq
146: AND WO.WIP_ENTITY_ID = WOY.WIP_ENTITY_ID
147: AND WO.OPERATION_SEQ_NUM = WOY.OPERATION_SEQ_NUM
288:
289: x_statement := 55;
290: SELECT bd.scrap_account,bd.est_absorption_account
291: INTO l_scrap_acct, l_est_scrap_abs_acct
292: FROM bom_departments bd, wip_operations wo
293: WHERE wo.operation_seq_num = rec_opseq.operation_seq_num
294: AND wo.wip_entity_id = rec_wip_entity.wip_entity_id
295: AND wo.organization_id = rec_wip_entity.organization_id
296: AND bd.department_id = wo.department_id
349: -- Initialize Parameters if first operation of job --
350: ---------------------------------------------------------
351: If x_first_operation THEN
352:
353: /* Bug 4599116 - Added the join with WIP_OPERATIONS table to avoid the
354: operations that are obsoleted due to undo move or
355: update assembly transactions. The obsoleted operation is determined
356: by a valid disable date */
357:
358: x_statement := 200;
359: SELECT count(*)
360: INTO x_count
361: FROM WIP_OPERATION_YIELDS woy,
362: WIP_OPERATIONS wo
363: WHERE woy.wip_entity_id = rec_wip_entity.wip_entity_id
364: and wo.wip_entity_id = woy.wip_entity_id
365: and woy.organization_id = x_organization_id
366: and wo.organization_id = x_organization_id
382: WHERE wip_entity_id = rec_wip_entity.wip_entity_id
383: and organization_id = x_organization_id
384: and operation_seq_num = (select max(woy.operation_seq_num)
385: from wip_operation_yields woy,
386: wip_operations wo
387: where woy.wip_entity_id = rec_wip_entity.wip_entity_id
388: and woy.organization_id = x_organization_id
389: and woy.operation_seq_num < rec_opseq.operation_seq_num
390: and woy.operation_seq_num = wo.operation_seq_num
395: x_statement := 230;
396: SELECT SUM( NVL(EST_SCRAP_UNIT_COST, 0))
397: INTO x_cum_pr_est_scp_per_unit
398: FROM WIP_OPERATION_YIELDS WOY,
399: WIP_OPERATIONS WO
400: WHERE woy.wip_entity_id = rec_wip_entity.wip_entity_id
401: and woy.organization_id = x_organization_id
402: and woy.operation_seq_num < rec_opseq.operation_seq_num
403: and woy.operation_seq_num = wo.operation_seq_num
417: ---------------------------------------------------------------
418: SELECT SUM( NVL(EST_SCRAP_UNIT_COST, 0))
419: INTO x_cum_pr_est_scp_per_unit
420: FROM WIP_OPERATION_YIELDS WOY,
421: WIP_OPERATIONS WO
422: WHERE woy.wip_entity_id = rec_wip_entity.wip_entity_id
423: and woy.organization_id = x_organization_id
424: and woy.operation_seq_num < rec_opseq.operation_seq_num
425: and woy.operation_seq_num = wo.operation_seq_num
1581: rj.common_routing_sequence_id routing_seq_id,
1582: smt.transaction_type_id txn_type_id
1583: from wsm_sm_resulting_jobs rj,
1584: wsm_split_merge_transactions smt,
1585: wip_operations wo,
1586: bom_operation_sequences bos
1587: where smt.transaction_id = i_txn_id
1588: and smt.transaction_type_id = 4
1589: and smt.transaction_id = rj.transaction_id
1601: p_op_seq_num Number,
1602: p_organization_id Number) IS
1603: SELECT wo.operation_seq_num,
1604: wdj.start_quantity
1605: FROM wip_operations wo,
1606: wip_discrete_jobs wdj
1607: WHERE wo.wip_entity_id = p_wip_entity_id
1608: AND wo.operation_seq_num <= p_op_seq_num
1609: AND wo.organization_id = p_organization_id