DBA Data[Home] [Help]

APPS.INV_LABEL_PVT9 dependencies on WIP_DISCRETE_JOBS

Line 336: , wip_discrete_jobs wipdj

332: , NULL lot_vendor
333: , NULL subinventory_code
334: , NULL LOCATOR
335: FROM wip_entities wipent
336: , wip_discrete_jobs wipdj
337: , mfg_lookups mfglkp1
338: , mfg_lookups mfglkp2
339: , mfg_lookups mfglkp3
340: , mtl_system_items_vl msik3

Line 403: , wip_discrete_jobs wdj -- added for bug 3776231

399: , mtl_material_transactions_temp mmtt
400: , mtl_transaction_lots_temp mtlt
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

Line 444: , wip_discrete_jobs wdj -- added for bug 3776231

440: , mtl_material_transactions_temp mmtt
441: , mtl_transaction_lots_temp mtlt
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

Line 751: , wip_discrete_jobs wipdj

747: , mln.vendor_name lot_vendor
748: , lpn.subinventory_code subinventory_code
749: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
750: FROM wip_entities wipent
751: , wip_discrete_jobs wipdj
752: , wip_repetitive_schedules wiprs
753: , wip_operations wipops
754: , wip_requirement_operations wipreqops
755: , mtl_item_locations mila

Line 1057: FROM wip_discrete_jobs wdj

1053: SELECT pp.SEGMENT1
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