[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT set_of_books_id
FROM pa_implementations;
SELECT period_set_name
, currency_code
FROM gl_ledgers_public_v
WHERE ledger_id = p_ledger_id;
SELECT start_date
FROM gl_periods
WHERE period_set_name = p_period_set_name
AND period_name = p_period_name;
SELECT end_date
FROM gl_periods
WHERE period_set_name = p_period_set_name
AND period_name = p_period_name;
|| ' AND EXISTS (select NULL'
|| ' from pa_cost_distribution_lines cdl1'
|| ' where cdl1.expenditure_item_id = ei.expenditure_item_id'
|| ' and cdl1.line_num = 1'
|| ' and NVL(cdl1.reversed_flag,''N'') <> ''Y'')'
|| ' AND ei.net_zero_adjustment_flag = ''N'''
|| ' AND ei.transferred_from_exp_item_id IS NULL'
|| ' AND EXISTS (select NULL'
|| ' from pa_expenditure_items ei2'
|| ' where (ei2.document_header_id, ei2.document_distribution_id) IN'
|| ' ( SELECT apdist2.invoice_id, apdist2.old_distribution_id'
|| ' from ap_invoice_distributions apdist1,'
|| ' ap_invoice_distributions apdist2 '
|| ' where ei.document_distribution_id = apdist1.invoice_distribution_id'
|| ' and NVL(apdist1.historical_flag,''N'') <> ''Y'''
|| ' and apdist1.reversal_flag = ''Y'''
|| ' and apdist1.parent_reversal_id = apdist2.invoice_distribution_id'
|| ' and apdist2.old_distribution_id IS NOT NULL)'
|| ' and ( ei2.net_zero_adjustment_flag = ''Y'''
|| ' OR EXISTS ( SELECT NULL'
|| ' FROM pa_cost_distribution_lines_all cdl2'
|| ' WHERE cdl2.expenditure_item_id = ei2.expenditure_item_id'
|| ' AND cdl2.line_num = 1'
|| ' AND cdl2.reversed_flag = ''Y''))) ';
|| ' AND EXISTS (select NULL'
|| ' from pa_cost_distribution_lines cdl1'
|| ' where cdl1.expenditure_item_id = ei.expenditure_item_id'
|| ' and cdl1.line_num = 1'
|| ' and NVL(cdl1.reversed_flag,''N'') <> ''Y'')'
|| ' AND ei.net_zero_adjustment_flag = ''N'''
|| ' AND ei.transferred_from_exp_item_id IS NULL'
|| ' AND EXISTS (select NULL'
|| ' from pa_expenditure_items ei2'
|| ' where (ei2.document_header_id, ei2.document_distribution_id) IN'
|| ' ( select rcv2.po_header_id, rcv2.transaction_id'
|| ' from rcv_transactions rcv1'
|| ' , rcv_transactions rcv2'
|| ' where rcv1.transaction_id = ei.document_distribution_id'
|| ' and rcv1.transaction_type in (''RETURN TO RECEIVING'',''RETURN TO VENDOR'',''CORRECT'')'
|| ' and rcv1.parent_transaction_id = rcv2.transaction_id)'
|| ' and ( ei2.net_zero_adjustment_flag = ''Y'''
|| ' OR EXISTS ( SELECT NULL'
|| ' FROM pa_cost_distribution_lines_all cdl2'
|| ' WHERE cdl2.expenditure_item_id = ei2.expenditure_item_id'
|| ' AND cdl2.line_num = 1'
|| ' AND cdl2.reversed_flag = ''Y''))) ';
SELECT
GL.NAME
FROM
GL_LEDGERS_PUBLIC_V GL,
PA_IMPLEMENTATIONS IMP
WHERE GL.LEDGER_ID = IMP.SET_OF_BOOKS_ID;
SELECT
MEANING
FROM
PA_LOOKUPS
WHERE LOOKUP_TYPE = 'MESSAGE'
AND LOOKUP_CODE = 'NO_DATA_FOUND';