DBA Data[Home] [Help]

APPS.PO_THIRD_PARTY_STOCK_GRP dependencies on PO_VENDOR_SITES_ALL

Line 171: po_vendor_sites_all pvs

167: INTO l_purch_flag ,
168: l_req_flag ,
169: l_sob_id
170: FROM FINANCIALS_SYSTEM_PARAMS_ALL fspa ,
171: po_vendor_sites_all pvs
172: WHERE pvs.vendor_site_id = p_supplier_site_id
173: AND NVL(fspa.org_id,-99) = NVL(pvs.org_id,-99) ;
174:
175: -- *** ENCUMBRANCE ACCOUNTING VALIDATION ***

Line 479: from po_vendor_sites_all pvsa ,

475: and msi.inventory_item_id = p_inventory_item_id
476: -- INVCONV and hoi.organization_id = imst.mtl_organization_id (+)
477: and GSOB.SET_OF_BOOKS_ID = (
478: select set_of_books_id
479: from po_vendor_sites_all pvsa ,
480: financials_system_params_all fspa
481: where pvsa.vendor_site_id = p_supplier_site_id
482: and NVL(fspa.org_id,-99)= NVL(pvsa.org_id,-99)
483: ) ;

Line 522: po_vendor_sites_all pvs

518: INTO l_purch_flag ,
519: l_req_flag ,
520: l_sob_id
521: FROM FINANCIALS_SYSTEM_PARAMS_ALL fspa ,
522: po_vendor_sites_all pvs
523: WHERE pvs.vendor_site_id = p_supplier_site_id
524: AND NVL(fspa.org_id,-99) = NVL(pvs.org_id,-99) ;
525:
526: -- *** ENCUMBRANCE ACCOUNTING VALIDATION ***