[Home] [Help]
2630: l_mv_lot,
2631: l_po_item,
2632: l_po_lot
2633: FROM wip_move_txn_interface wmti,
2634: wip_operation_resources wor
2635: WHERE wmti.transaction_id = p_gib.group_id
2636: AND wmti.group_id = p_gib.group_id
2637: AND wor.organization_id = l_move.org_id
2638: AND wor.wip_entity_id = l_move.wip_id
2670: END IF;
2671: /* Fix for bug 3902908: Added hints as per suggestion of appsperf team. */
2672: /* Fix for FP bug 5246228 base bug 5227706: Modified following query to consider autocharge
2673: resources in previous operation for overcompletion cases */
2674: SELECT /*+ leading(wti) use_nl(wti wor) index(wor WIP_OPERATION_RESOURCES_U1) */
2675: SUM(DECODE(basis_type,1,DECODE(autocharge_type,1,1,0),0)),
2676: SUM(DECODE(basis_type,2,DECODE(autocharge_type,1,1,0),0)),
2677: SUM(DECODE(to_intraoperation_step_type,1,DECODE(basis_type,1,
2678: DECODE(autocharge_type,3,1,4,1,0),0))),
2682: l_mv_lot,
2683: l_po_item,
2684: l_po_lot
2685: FROM wip_move_txn_interface wmti,
2686: wip_operation_resources wor
2687: WHERE wmti.group_id = p_gib.group_id
2688: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
2689: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
2690: AND wmti.process_status = WIP_CONSTANTS.RUNNING
3401: wdj.task_id
3402: FROM bom_departments bd,
3403: bom_resources br,
3404: cst_activities ca,
3405: wip_operation_resources wor,
3406: wip_discrete_jobs wdj,
3407: wip_operations wop,
3408: wip_move_txn_interface wmti
3409: WHERE wmti.group_id = p_gib.group_id
3613: NULL -- repetitive_schedule_id
3614: FROM bom_departments bd,
3615: bom_resources br,
3616: cst_activities ca,
3617: wip_operation_resources wor,
3618: wip_move_txn_allocations wma,
3619: wip_operations wop,
3620: wip_move_txn_interface wmti
3621: WHERE wmti.group_id = p_gib.group_id
3698: /*------------------------------------------------------------+
3699: | Per order basis type for discrete jobs
3700: department_id cannot be changed so we can take the MAX,
3701: also columns such as usage_rate_or_amount are not part of
3702: the transaction they are looked up in wip_operation_resources
3703: +------------------------------------------------------------*/
3704: IF(l_move.jobTxn = WIP_CONSTANTS.YES AND
3705: l_move.rsrcLot = WIP_CONSTANTS.YES) THEN
3706:
3854: MAX(wdj.task_id)
3855: FROM bom_departments bd,
3856: bom_resources br,
3857: cst_activities ca,
3858: wip_operation_resources wor,
3859: wip_discrete_jobs wdj,
3860: wip_operations wop,
3861: wip_move_txn_interface wmti
3862: WHERE wmti.group_id = p_gib.group_id
4065: wma.repetitive_schedule_id
4066: FROM bom_departments bd,
4067: bom_resources br,
4068: cst_activities ca,
4069: wip_operation_resources wor,
4070: wip_move_txn_allocations wma,
4071: wip_operations wop,
4072: wip_move_txn_interface wmti
4073: WHERE wmti.group_id = p_gib.group_id
4275: 0, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0),
4276: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
4277: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
4278:
4279: FROM wip_operation_resources wor,
4280: wip_operations wop,
4281: wip_move_txn_allocations wma,
4282: wip_cost_txn_interface wci,
4283: wip_move_txn_interface wmti
4428: 1, -1, DECODE(SIGN(wmti.to_intraoperation_step_type -
4429: WIP_CONSTANTS.RUN),1, 1, -1)),
4430: 1, 1,
4431: -1,-1) -- primary_quantity
4432: FROM wip_operation_resources wor,
4433: wip_move_txn_allocations wmta,
4434: wip_move_txn_interface wmti,
4435: wip_cost_txn_interface wcti
4436: WHERE wcti.group_id = p_gib.group_id
4691: MAX(wdj.project_id),
4692: MAX(wdj.task_id)
4693: FROM bom_departments bd,
4694: wip_operations wop,
4695: wip_operation_resources wor,
4696: wip_discrete_jobs wdj,
4697: wip_move_txn_interface wmti,
4698: wip_requirement_operations WRO
4699: WHERE wmti.group_id = p_gib.group_id
4915: FROM bom_departments bd,
4916: wip_move_txn_allocations wma,
4917: wip_operations wop,
4918: wip_move_txn_interface wmti,
4919: wip_operation_resources wor
4920: WHERE wmti.group_id = p_gib.group_id
4921: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
4922: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
4923: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5150: MAX(wdj.project_id),
5151: MAX(wdj.task_id)
5152: FROM bom_departments bd,
5153: wip_operations wop,
5154: wip_operation_resources wor,
5155: wip_discrete_jobs wdj,
5156: wip_move_txn_interface wmti
5157: WHERE wmti.group_id = p_gib.group_id
5158: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5367: FROM bom_departments bd,
5368: wip_move_txn_allocations wma,
5369: wip_operations wop,
5370: wip_move_txn_interface wmti,
5371: wip_operation_resources wor
5372: WHERE wmti.group_id = p_gib.group_id
5373: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5374: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5375: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5706: wo.operation_seq_num op_seq_num,
5707: wmti.overcompletion_primary_qty oc_qty
5708: FROM wip_move_txn_interface wmti,
5709: wip_operations wo,
5710: wip_operation_resources wor,
5711: wip_discrete_jobs wdj
5712: WHERE wmti.group_id = p_group_id
5713: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5714: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5735: wo.operation_seq_num op_seq_num,
5736: wmti.overcompletion_primary_qty oc_qty
5737: FROM wip_move_txn_interface wmti,
5738: wip_operations wo,
5739: wip_operation_resources wor,
5740: wip_repetitive_schedules wrs
5741: WHERE wmti.group_id = p_group_id
5742: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5743: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5921: wdj.task_id,
5922: DECODE(wdj.project_id,NULL,NULL,'Y')-- project_accounting_context
5923: FROM /* bugfix 5129403: modified the order in the from clause */
5924: wip_move_txn_interface wmti,
5925: wip_operation_resources wor,
5926: bom_resources br,
5927: mtl_system_items msi,
5928: mtl_parameters mp,
5929: -- bom_calendar_dates bcd2, Bug 4398047 join to bcd2 not required
6137: mtl_parameters mp,
6138: hr_organization_information hoi,
6139: wip_entities we,
6140: wip_repetitive_schedules wrs,
6141: wip_operation_resources wor,
6142: wip_operations wo1,
6143: wip_operations wo2,
6144: wip_move_txn_allocations wma,
6145: wip_move_txn_interface wmti
6331: wdj.task_id,
6332: DECODE(wdj.project_id,NULL,NULL,'Y')-- project_accounting_context
6333: FROM /* bugfix 5129403: modified the order in the from clause */
6334: wip_move_txn_interface wmti,
6335: wip_operation_resources wor,
6336: bom_resources br,
6337: mtl_system_items msi,
6338: mtl_parameters mp,
6339: -- bom_calendar_dates bcd2, Bug 4398047 join no longer required
6563: mtl_item_revisions mir,
6564: mtl_system_items msi,
6565: mtl_parameters mp,
6566: hr_organization_information hoi,
6567: wip_operation_resources wor,
6568: wip_repetitive_schedules wrs,
6569: wip_entities we,
6570: wip_operations wo1,
6571: wip_operations wo2,
6748: wmti.to_operation_seq_num op_seq_num,
6749: wor.autocharge_type autocharge_type
6750: FROM bom_resources br,
6751: mtl_units_of_measure muom,
6752: wip_operation_resources wor,
6753: wip_operations wo,
6754: wip_move_txn_interface wmti
6755: WHERE wmti.group_id = p_group_id
6756: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC