APPS.ICX_RQS_ATTACHMENT SQL Statements

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

Line: 43

select  rowidtochar(ROWID)
into    c_rowid
from    AK_FLOW_REGION_RELATIONS
where   FROM_REGION_CODE = 'ICX_RQS_HISTORY_1'
and     FROM_REGION_APPL_ID = 178
and     FROM_PAGE_CODE = 'ICX_RQS_HISTORY_1'
and     FROM_PAGE_APPL_ID = 178
and     TO_PAGE_CODE = 'ICX_RQS_HISTORY_DTL_D'
and     TO_PAGE_APPL_ID = 178
and     FLOW_CODE = 'ICX_EMPLOYEES'
and     FLOW_APPLICATION_ID = 178;

Line: 119

select  rowidtochar(ROWID)
into    c_rowid
from    AK_FLOW_REGION_RELATIONS
where   FROM_REGION_CODE = 'ICX_RQS_HISTORY_1'
and     FROM_REGION_APPL_ID = 178
and     FROM_PAGE_CODE = 'ICX_RQS_HISTORY_1'
and     FROM_PAGE_APPL_ID = 178
and     TO_PAGE_CODE = 'ICX_RQS_HISTORY_DTL_D'
and     TO_PAGE_APPL_ID = 178
and     FLOW_CODE = 'ICX_EMPLOYEES'
and     FLOW_APPLICATION_ID = 178;

Line: 198

select  rowidtochar(ROWID)
into    c_rowid
from    AK_FLOW_REGION_RELATIONS
where   FROM_REGION_CODE = 'ICX_RQS_HISTORY_1'
and     FROM_REGION_APPL_ID = 178
and     FROM_PAGE_CODE = 'ICX_RQS_HISTORY_1'
and     FROM_PAGE_APPL_ID = 178
and     TO_PAGE_CODE = 'ICX_RQS_HISTORY_DTL_D'
and     TO_PAGE_APPL_ID = 178
and     FLOW_CODE = 'ICX_EMPLOYEES'
and     FLOW_APPLICATION_ID = 178;

Line: 221

select REQUISITION_HEADER_ID into pk1
from icx_po_requisition_open_v
where REQUISITION_LINE_ID = c_inputs1;