APPS.PO_VMI_GRP dependencies on PO_VENDOR_SITES

Line 58: po_vendor_sites pvs ,

54: FROM dual
55: WHERE exists
56: ( SELECT 'X'
57: FROM po_approved_supplier_list pasl,
58: po_vendor_sites pvs ,
59: po_asl_status_rules_v pasr ,
60: po_asl_attributes paa
61: WHERE pasl.vendor_site_id = pvs.vendor_site_id
62: AND pasr.status_id = pasl.asl_status_id

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: