DBA Data[Home] [Help]

APPS.INV_LABEL_PVT9 dependencies on PA_PROJECTS

Line 375: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, pa_projects pp, pa_tasks pt

371: , mmtt.cost_group_id
372: , mmtt.subinventory_code
373: , pp.NAME
374: , pt.task_name
375: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, pa_projects pp, pa_tasks pt
376: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
377: AND mmtt.project_id = pp.project_id(+)
378: AND mmtt.task_id = pt.task_id(+)
379: AND mmtt.transaction_temp_id = p_transaction_id;

Line 405: , pa_projects pp

401: -- bug 3075322
402: -- , mtl_item_locations mil commented for bug 3776231
403: , wip_discrete_jobs wdj -- added for bug 3776231
404: -- Bug 2673874 : joabraha
405: , pa_projects pp
406: , pa_tasks pt
407: WHERE mtrl.line_id = mmtt.move_order_line_id
408: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
409: /*commented for bug 3776231

Line 446: , pa_projects pp

442: -- bug 3075322
443: -- , mtl_item_locations mil commented for bug 3776231
444: , wip_discrete_jobs wdj -- added for bug 3776231
445: -- Bug 2673874 : joabraha
446: , pa_projects pp
447: , pa_tasks pt
448: WHERE mtrl.line_id = mmtt.move_order_line_id
449: AND mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
450: /*commented for bug 3776231

Line 1058: , pa_projects_all pp

1054: , pt.TASK_NUMBER
1055: INTO l_project_name
1056: , l_task_name
1057: FROM wip_discrete_jobs wdj
1058: , pa_projects_all pp
1059: , pa_tasks pt
1060: WHERE wdj.wip_entity_id = l_wip_entity_id
1061: AND wdj.organization_id = l_organization_id
1062: AND pp.project_id(+) = wdj.project_id