DBA Data[Home] [Help]

APPS.INL_INTEGRATION_GRP dependencies on PO_VENDORS

Line 820: p_debug_info => 'Get Party Id from PO_VENDORS');

816: IF l_source_document_code = 'PO' THEN
817: INL_LOGGING_PVT.Log_Statement (
818: p_module_name => g_module_name,
819: p_procedure_name => l_proc_name,
820: p_debug_info => 'Get Party Id from PO_VENDORS');
821:
822: SELECT party_id
823: INTO l_party_id
824: FROM po_vendors

Line 824: FROM po_vendors

820: p_debug_info => 'Get Party Id from PO_VENDORS');
821:
822: SELECT party_id
823: INTO l_party_id
824: FROM po_vendors
825: WHERE vendor_id = l_vendor_id;
826: ELSIF l_source_document_code = 'RMA' THEN
827: INL_LOGGING_PVT.Log_Statement (
828: p_module_name => g_module_name,

Line 3050: FROM po_vendors pv

3046:
3047: -- Get Party Id
3048: SELECT pv.party_id
3049: INTO l_party_id
3050: FROM po_vendors pv
3051: WHERE pv.vendor_id = p_po_hdr_rec.vendor_id;
3052:
3053: INL_LOGGING_PVT.Log_Variable (
3054: p_module_name => g_module_name,

Line 4314: po_vendors pv1,

4310: l_simu_vendor_site_code,
4311: l_po_release_num, -- Bug 14280113
4312: l_po_release_revision_num -- Bug 14280113
4313: FROM po_vendor_sites pvs1,
4314: po_vendors pv1,
4315: po_vendor_sites pvs,
4316: po_vendors pv,
4317: po_releases pr, -- Bug 14280113
4318: po_headers_all ph,

Line 4316: po_vendors pv,

4312: l_po_release_revision_num -- Bug 14280113
4313: FROM po_vendor_sites pvs1,
4314: po_vendors pv1,
4315: po_vendor_sites pvs,
4316: po_vendors pv,
4317: po_releases pr, -- Bug 14280113
4318: po_headers_all ph,
4319: inl_simulations s
4320: WHERE pr.po_header_id (+) = ph.po_header_id -- Bug 14280113