APPS.POS_WF_PO_COMMON_APIS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 86

  select  rowidtochar(ROWID)
  into    p_rowid
  from    AK_FLOW_REGION_RELATIONS
  where   FROM_REGION_CODE = 'ICX_PO_HEADERS_D'
  and     FROM_REGION_APPL_ID = 178
  and     FROM_PAGE_CODE = 'ICX_PO_HEADERS_D'
  and     FROM_PAGE_APPL_ID = 178
  and     TO_PAGE_CODE = 'ICX_PO_HEADERS_DTL_D'
  and     TO_PAGE_APPL_ID = 178
  and     FLOW_CODE = 'ICX_INQUIRIES'
  and     FLOW_APPLICATION_ID = 178;

Line: 223

	select inventory_organization_id
	into x_def_inv_org
	from financials_system_parameters;

Line: 262

	select buyer_id into x_buyer_id
	from mtl_system_items
	where inventory_item_id = x_item_id
	and   organization_id	= x_default_inv_org;

Line: 306

			select vendor_id into x_vendor_id
			from po_headers_all
			where po_header_id = x_document_id;

Line: 319

				select vendor_id
				into x_vendor_id
				from po_headers_all
				where po_header_id = (select po_header_id from po_releases_all
							where po_release_id = x_document_id);

Line: 336

			select vendor_name into x_vendor
			from po_vendors
			where vendor_id = x_vendor_id;

Line: 375

	select nvl(revision_num, 0)
	into x_doc_revision
	from po_headers
	where po_header_id = x_document_id;