DBA Data[Home] [Help]

APPS.WIP_PROD_INDICATORS dependencies on WIP_ENTITIES

Line 2844: from wip_entities we,

2840: wit.last_update_login,
2841: wit.request_id,
2842: wit.program_application_id,
2843: sysdate
2844: from wip_entities we,
2845: wip_bis_eff_temp wit
2846: where we.wip_entity_id = wit.wip_entity_id
2847: and we.organization_id = wit.organization_id
2848: and wit.indicator_type = WIP_EFFICIENCY

Line 3007: from wip_entities we,

3003: wit.last_update_login,
3004: wit.request_id,
3005: wit.program_application_id,
3006: sysdate
3007: from wip_entities we,
3008: wip_bis_utz_temp wit
3009: where we.wip_entity_id = wit.wip_entity_id
3010: and we.organization_id = wit.organization_id
3011: and wit.indicator_type = WIP_UTILIZATION

Line 3115: from wip_entities we,

3111: wit.last_update_login,
3112: wit.request_id,
3113: wit.program_application_id,
3114: sysdate
3115: from wip_entities we,
3116: wip_bis_yld_temp wit
3117: where we.wip_entity_id = wit.wip_entity_id
3118: and we.organization_id = wit.organization_id
3119: and wit.indicator_type = WIP_YIELD

Line 3252: FROM wip_entities we,

3248: wit.last_update_login,
3249: wit.request_id,
3250: wit.program_application_id,
3251: sysdate
3252: FROM wip_entities we,
3253: wip_bis_yld_temp wit
3254: WHERE we.wip_entity_id = wit.wip_entity_id
3255: AND we.organization_id = wit.organization_id
3256: AND wit.indicator_type = WIP_YIELD

Line 3930: wip_entities we,

3926: sysdate,
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,

Line 6136: FROM wip_entities we,

6132: wit.last_update_login,
6133: wit.request_id,
6134: wit.program_application_id,
6135: sysdate
6136: FROM wip_entities we,
6137: wip_bis_yld_temp wit3,
6138: wip_bis_utz_temp wit2,
6139: wip_bis_eff_temp wit
6140: WHERE