DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on JMF_SHIKYU_REPLENISHMENTS

Line 632: ,jmf_shikyu_replenishments repo

628: --updated to fix project_number related issue start
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

Line 1071: ,jmf_shikyu_replenishments repo

1067: FROM oe_order_headers_all soh
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