DBA Data[Home] [Help]

APPS.PO_VMI_GRP dependencies on HR_ORGANIZATION_INFORMATION

Line 134: hr_organization_information hoi ,

130: msi.replenish_to_order_flag ,
131: msi.auto_created_config_flag
132: from gl_sets_of_books gsob ,
133: hr_organization_units hou ,
134: hr_organization_information hoi ,
135: mtl_parameters mp ,
136: hr_organization_information hoi2 ,
137: mtl_system_items msi ,
138: ic_whse_mst imst

Line 136: hr_organization_information hoi2 ,

132: from gl_sets_of_books gsob ,
133: hr_organization_units hou ,
134: hr_organization_information hoi ,
135: mtl_parameters mp ,
136: hr_organization_information hoi2 ,
137: mtl_system_items msi ,
138: ic_whse_mst imst
139: where HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
140: and HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

Line 152: HR_ORGANIZATION_INFORMATION HOI ,

148: and hoi.organization_id = imst.mtl_organization_id (+)
149: and GSOB.SET_OF_BOOKS_ID = (
150: select set_of_books_id
151: from po_vendor_sites_all pvsa ,
152: HR_ORGANIZATION_INFORMATION HOI ,
153: GL_SETS_OF_BOOKS GSOB
154: where pvsa.vendor_site_id = x_supplier_site_id
155: and NVL(DECODE(HOI.ORG_INFORMATION_CONTEXT,'Accounting Information',
156: TO_NUMBER(HOI.ORG_INFORMATION3),TO_NUMBER(NULL)),-99)= NVL(pvsa.org_id,-99)