DBA Data[Home] [Help]

APPS.ICX_EXT_SUPPLIER SQL Statements

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

Line: 13

	SELECT fu.user_name, ipss.company, iri.operating_unit,
		 iri.ship_to, iri.deliver_to, iri.req_token,
		 iri.http_host, ipss.callback_URL
	FROM 	 icx_procurement_server_setup ipss,
		 icx_sessions ics, fnd_user fu,
		 icx_requisitioner_info iri,
                 icx_por_item_sources it
	WHERE	 ics.disabled_flag = 'N'
	AND	 iri.session_id = ics.session_id
	AND 	 ics.user_id = fu.user_id
	AND 	 iri.encrypted_session_id = ticket
        AND      it.item_source_id = ipss.item_source_id
        AND      it.protocol_supported is null;