DBA Data[Home] [Help]

APPS.PO_VMI_GRP dependencies on PO_VENDOR_SITES_ALL

Line 151: from po_vendor_sites_all pvsa ,

147: and msi.inventory_item_id = x_inventory_item_id
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',

Line 170: po_vendor_sites_all pvs

166: fspa.req_encumbrance_flag
167: INTO l_purch_encumbrance_flag ,
168: l_req_encumbrance_flag
169: FROM FINANCIALS_SYSTEM_PARAMS_ALL fspa ,
170: po_vendor_sites_all pvs
171: WHERE pvs.vendor_site_id = x_supplier_site_id
172: AND NVL(fspa.org_id,-99) = NVL(pvs.org_id,-99) ;
173:
174: