DBA Data[Home] [Help]

APPS.JMF_SHIKYU_RPT_CUR_PVT dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 276: ,hr_all_organization_units_tl haotl

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
279: ,po_vendors ven
280: WHERE \*h.type_lookup_code IN ('STANDARD') AND *\

Line 312: ,hr_all_organization_units_tl haotl

308: ,po_lines_all l
309: ,po_headers_all h
310: ,hr_organization_information hoi
311: ,mtl_interorg_parameters mip
312: ,hr_all_organization_units_tl haotl
313: --Added to display release_number
314: ,po_releases_all pra
315: --updated to fix project_number related issue start
316: --WHERE /*h.type_lookup_code IN ('standard') AND */

Line 627: ,hr_all_organization_units_tl haotl

623: ,sol.pricing_quantity_uom) exchange_UOM-- returns qty in primary UOM for 1 UOM in document
624: ,sol.line_id
625: FROM oe_order_headers_all soh
626: ,oe_order_lines_all sol
627: ,hr_all_organization_units_tl haotl
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

Line 920: ,hr_all_organization_units_tl haotl

916: ,rcv.transaction_id
917: FROM rcv_transactions rcv
918: ,oe_order_lines_all oel
919: ,oe_order_headers_all oeh
920: ,hr_all_organization_units_tl haotl
921: WHERE oel.org_id = lp_org_id
922: AND rcv.transaction_type = 'DELIVER'
923: AND oel.line_id = rcv.oe_order_line_id
924: AND rcv.organization_id = oel.ship_from_org_id