DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on WIP_OPERATIONS

Line 1758: wip_operations wo,

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))
1762: and trunc(nvl(p_date_to,wmt.transaction_date))

Line 2352: wip_operations wo,

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))
2356: -- below statement is equavivalent to between only. Dont know why such a complex condition.

Line 4806: wip_operations_v wo,

4802: from
4803: mrp_net_resource_avail mnra,
4804: bom_departments bd,
4805: bom_department_resources bdr,
4806: wip_operations_v wo,
4807: wip_operation_resources_v wor,
4808: wip_discrete_jobs wdj
4809: where
4810: wdj.wip_entity_id = wor.wip_entity_id