DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 274: ,mtl_system_items_vl mtl

270: /* FROM po_headers_all h
271: ,po_lines_all l
272: ,po_line_locations_all loc
273: ,jmf_subcontract_orders sub
274: ,mtl_system_items_vl mtl
275: ,po_vendor_sites_all pv
276: ,hr_all_organization_units_tl haotl
277: ,pa_projects_all pa
278: ,pa_tasks tasks

Line 305: ,mtl_system_items_vl mtl

301: FROM pa_tasks tasks
302: --updated to fix project_number related issue end
303: ,po_vendor_sites_all pv
304: ,po_vendors ven
305: ,mtl_system_items_vl mtl
306: ,jmf_subcontract_orders sub
307: ,po_line_locations_all loc
308: ,po_lines_all l
309: ,po_headers_all h

Line 633: ,mtl_system_items_vl mtl

629: --,pa_projects_all pa
630: --updated to fix project_number related issue end
631: ,pa_tasks tasks
632: ,jmf_shikyu_replenishments repo
633: ,mtl_system_items_vl mtl
634: --updated to fix project_number related issue start
635: --WHERE pa.project_id(+) = sol.project_id
636: -- AND tasks.task_id(+) = sol.task_id
637: WHERE tasks.task_id(+) = sol.task_id

Line 1072: ,mtl_system_items_vl mtl

1068: ,oe_order_lines_all sol
1069: ,pa_projects_all pa
1070: ,pa_tasks tasks
1071: ,jmf_shikyu_replenishments repo
1072: ,mtl_system_items_vl mtl
1073: WHERE pa.project_id(+) = sol.project_id
1074: AND tasks.task_id(+) = sol.task_id
1075: AND mtl.inventory_item_id = sol.inventory_item_id
1076: AND mtl.organization_id = l_ship_from_org_id