APPS.WIP_PROD_INDICATORS dependencies on WIP_MOVE_TRANSACTIONS

Line 1757: wip_move_transactions wmt,

1753: SYSDATE,
1754: g_userid,
1755: g_applicationid
1756: from
1757: wip_move_transactions wmt,
1758: wip_operations wo,
1759: bom_departments bd
1760: where
1761: trunc(wmt.transaction_date) between trunc(nvl(p_date_from,wmt.transaction_date))

Line 2351: wip_move_transactions wmt,

2347: SYSDATE,
2348: g_userid,
2349: g_applicationid
2350: from
2351: wip_move_transactions wmt,
2352: wip_operations wo,
2353: bom_departments bd
2354: where trunc(wmt.transaction_date) between trunc(nvl(p_date_from,wmt.transaction_date))
2355: and trunc(nvl(p_date_to,wmt.transaction_date))

Line 2495: SELECT /* WIP_MOVE_TRANSACTIONS_N2 */

2491: p_group_id number,
2492: p_org_id number,
2493: p_date_from date,
2494: p_date_to date ) IS
2495: SELECT /* WIP_MOVE_TRANSACTIONS_N2 */
2496: organization_id,
2497: wip_entity_id,
2498: fm_operation_seq_num,
2499: to_operation_seq_num,

Line 2504: FROM wip_move_transactions

2500: fm_intraoperation_step_type,
2501: to_intraoperation_step_type,
2502: primary_quantity,
2503: trunc(transaction_date) transaction_date
2504: FROM wip_move_transactions
2505: WHERE ( trunc(transaction_date) >= trunc(nvl(p_date_from,transaction_date))
2506: AND trunc(transaction_date) <= trunc(nvl(p_date_to,transaction_date)) )-- Or is replace AND Bug 3280671
2507: --( trunc(transaction_date) >= trunc(nvl(p_date_from,transaction_date))
2508: --OR trunc(transaction_date) <= trunc(nvl(p_date_to,transaction_date)) )

Line 2535: FROM wip_move_transactions wmt

2531:
2532: UPDATE wip_indicators_temp wit
2533: SET wit.scrap_quantity = (
2534: SELECT nvl(sum(wmt.primary_quantity),0)
2535: FROM wip_move_transactions wmt
2536: WHERE wmt.wip_entity_id = wit.wip_entity_id
2537: AND wmt.to_operation_seq_num = wit.operation_seq_num
2538: AND wmt.organization_id = wit.organization_id
2539: AND wmt.to_intraoperation_step_type = 5

Line 3880: FROM wip_move_transactions wmt

3876: 5, -1*(primary_quantity),
3877: decode(wmt.to_intraoperation_step_type,
3878: 5, primary_quantity,
3879: 0 ))),0)
3880: FROM wip_move_transactions wmt
3881: WHERE wmt.wip_entity_id = wbpay.wip_entity_id
3882: AND wmt.organization_id = wbpay.organization_id
3883: AND trunc(wmt.transaction_date)= trunc(wbpay.transaction_date)
3884: AND (wmt.fm_intraoperation_step_type = 5

Line 3931: wip_move_transactions wmt

3927: g_userid,
3928: g_applicationid
3929: FROM
3930: wip_entities we,
3931: wip_move_transactions wmt
3932: WHERE we.wip_entity_id = wmt.wip_entity_id
3933: AND we.organization_id = wmt.organization_id
3934: AND wmt.organization_id = nvl(p_organization_id,
3935: wmt.organization_id)