[Home] [Help]
2759: l_mv_lot,
2760: l_po_item,
2761: l_po_lot
2762: FROM wip_move_txn_interface wmti,
2763: wip_operation_resources wor
2764: WHERE wmti.transaction_id = p_gib.group_id
2765: AND wmti.group_id = p_gib.group_id
2766: AND wor.organization_id = l_move.org_id
2767: AND wor.wip_entity_id = l_move.wip_id
2799: END IF;
2800: /* Fix for bug 3902908: Added hints as per suggestion of appsperf team. */
2801: /* Fix for FP bug 5246228 base bug 5227706: Modified following query to consider autocharge
2802: resources in previous operation for overcompletion cases */
2803: SELECT /*+ leading(wti) use_nl(wti wor) index(wor WIP_OPERATION_RESOURCES_U1) */
2804: SUM(DECODE(basis_type,1,DECODE(autocharge_type,1,1,0),0)),
2805: SUM(DECODE(basis_type,2,DECODE(autocharge_type,1,1,0),0)),
2806: SUM(DECODE(to_intraoperation_step_type,1,DECODE(basis_type,1,
2807: DECODE(autocharge_type,3,1,4,1,0),0))),
2811: l_mv_lot,
2812: l_po_item,
2813: l_po_lot
2814: FROM wip_move_txn_interface wmti,
2815: wip_operation_resources wor
2816: WHERE wmti.group_id = p_gib.group_id
2817: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
2818: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
2819: AND wmti.process_status = WIP_CONSTANTS.RUNNING
3530: wdj.task_id
3531: FROM bom_departments bd,
3532: bom_resources br,
3533: cst_activities ca,
3534: wip_operation_resources wor,
3535: wip_discrete_jobs wdj,
3536: wip_operations wop,
3537: wip_move_txn_interface wmti
3538: WHERE wmti.group_id = p_gib.group_id
3742: NULL -- repetitive_schedule_id
3743: FROM bom_departments bd,
3744: bom_resources br,
3745: cst_activities ca,
3746: wip_operation_resources wor,
3747: wip_move_txn_allocations wma,
3748: wip_operations wop,
3749: wip_move_txn_interface wmti
3750: WHERE wmti.group_id = p_gib.group_id
3827: /*------------------------------------------------------------+
3828: | Per order basis type for discrete jobs
3829: department_id cannot be changed so we can take the MAX,
3830: also columns such as usage_rate_or_amount are not part of
3831: the transaction they are looked up in wip_operation_resources
3832: +------------------------------------------------------------*/
3833: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
3834: l_move.rsrcLot = WIP_CONSTANTS.YES) THEN
3835:
3983: MAX(wdj.task_id)
3984: FROM bom_departments bd,
3985: bom_resources br,
3986: cst_activities ca,
3987: wip_operation_resources wor,
3988: wip_discrete_jobs wdj,
3989: wip_operations wop,
3990: wip_move_txn_interface wmti
3991: WHERE wmti.group_id = p_gib.group_id
4194: wma.repetitive_schedule_id
4195: FROM bom_departments bd,
4196: bom_resources br,
4197: cst_activities ca,
4198: wip_operation_resources wor,
4199: wip_move_txn_allocations wma,
4200: wip_operations wop,
4201: wip_move_txn_interface wmti
4202: WHERE wmti.group_id = p_gib.group_id
4404: 0, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0),
4405: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
4406: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
4407:
4408: FROM wip_operation_resources wor,
4409: wip_operations wop,
4410: wip_move_txn_allocations wma,
4411: wip_cost_txn_interface wci,
4412: wip_move_txn_interface wmti
4557: 1, -1, DECODE(SIGN(wmti.to_intraoperation_step_type -
4558: WIP_CONSTANTS.RUN),1, 1, -1)),
4559: 1, 1,
4560: -1,-1) -- primary_quantity
4561: FROM wip_operation_resources wor,
4562: wip_move_txn_allocations wmta,
4563: wip_move_txn_interface wmti,
4564: wip_cost_txn_interface wcti
4565: WHERE wcti.group_id = p_gib.group_id
4820: MAX(wdj.project_id),
4821: MAX(wdj.task_id)
4822: FROM bom_departments bd,
4823: wip_operations wop,
4824: wip_operation_resources wor,
4825: wip_discrete_jobs wdj,
4826: wip_move_txn_interface wmti,
4827: wip_requirement_operations WRO
4828: WHERE wmti.group_id = p_gib.group_id
5044: FROM bom_departments bd,
5045: wip_move_txn_allocations wma,
5046: wip_operations wop,
5047: wip_move_txn_interface wmti,
5048: wip_operation_resources wor
5049: WHERE wmti.group_id = p_gib.group_id
5050: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5051: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5052: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5279: MAX(wdj.project_id),
5280: MAX(wdj.task_id)
5281: FROM bom_departments bd,
5282: wip_operations wop,
5283: wip_operation_resources wor,
5284: wip_discrete_jobs wdj,
5285: wip_move_txn_interface wmti
5286: WHERE wmti.group_id = p_gib.group_id
5287: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5496: FROM bom_departments bd,
5497: wip_move_txn_allocations wma,
5498: wip_operations wop,
5499: wip_move_txn_interface wmti,
5500: wip_operation_resources wor
5501: WHERE wmti.group_id = p_gib.group_id
5502: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5503: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5504: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5835: wo.operation_seq_num op_seq_num,
5836: wmti.overcompletion_primary_qty oc_qty
5837: FROM wip_move_txn_interface wmti,
5838: wip_operations wo,
5839: wip_operation_resources wor,
5840: wip_discrete_jobs wdj
5841: WHERE wmti.group_id = p_group_id
5842: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5843: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5864: wo.operation_seq_num op_seq_num,
5865: wmti.overcompletion_primary_qty oc_qty
5866: FROM wip_move_txn_interface wmti,
5867: wip_operations wo,
5868: wip_operation_resources wor,
5869: wip_repetitive_schedules wrs
5870: WHERE wmti.group_id = p_group_id
5871: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5872: AND wmti.process_status = WIP_CONSTANTS.RUNNING
6055: wdj.task_id,
6056: DECODE(wdj.project_id,NULL,NULL,'Y')-- project_accounting_context
6057: FROM /* bugfix 5129403: modified the order in the from clause */
6058: wip_move_txn_interface wmti,
6059: wip_operation_resources wor,
6060: bom_resources br,
6061: mtl_system_items msi,
6062: mtl_parameters mp,
6063: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
6278: mtl_parameters mp,
6279: hr_organization_information hoi,
6280: wip_entities we,
6281: wip_repetitive_schedules wrs,
6282: wip_operation_resources wor,
6283: wip_operations wo1,
6284: wip_operations wo2,
6285: wip_move_txn_allocations wma,
6286: wip_move_txn_interface wmti,
6479: wdj.task_id,
6480: DECODE(wdj.project_id,NULL,NULL,'Y')-- project_accounting_context
6481: FROM /* bugfix 5129403: modified the order in the from clause */
6482: wip_move_txn_interface wmti,
6483: wip_operation_resources wor,
6484: bom_resources br,
6485: mtl_system_items msi,
6486: mtl_parameters mp,
6487: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6718: mtl_item_revisions mir,
6719: mtl_system_items msi,
6720: mtl_parameters mp,
6721: hr_organization_information hoi,
6722: wip_operation_resources wor,
6723: wip_repetitive_schedules wrs,
6724: wip_entities we,
6725: wip_operations wo1,
6726: wip_operations wo2,
6905: wmti.to_operation_seq_num op_seq_num,
6906: wor.autocharge_type autocharge_type
6907: FROM bom_resources br,
6908: mtl_units_of_measure muom,
6909: wip_operation_resources wor,
6910: wip_operations wo,
6911: wip_move_txn_interface wmti
6912: WHERE wmti.group_id = p_group_id
6913: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
8542: AND organization_id = l_update_po.org_id;
8543:
8544: SELECT NVL(Min(operation_seq_num),0)
8545: into l_osp_op_seq_num
8546: FROM wip_operation_resources
8547: WHERE wip_entity_id = l_update_po.job_id
8548: AND organization_id = l_update_po.org_id
8549: AND autocharge_type IN (WIP_CONSTANTS.PO_RECEIPT, WIP_CONSTANTS.PO_MOVE);
8550: