APPS.JA_CN_GBI_EXPORT_PKG SQL Statements

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

Line: 62

SELECT
  fifs.concatenated_segment_delimiter separator
, jcask.concatenated_segments         account_structure
FROM
  FND_ID_FLEX_STRUCTURES       fifs
, ja_cn_account_structures_kfv jcask
, ja_cn_sub_acc_sources_all    jcsasa
WHERE  fifs.id_flex_num = jcask.structure_id
  AND  jcask.account_structure_id = jcsasa.accounting_struct_id
  AND  jcsasa.chart_of_accounts_id = pn_coa_id;

Line: 77

SELECT length(MAX(rra.axis_seq))
FROM
  rg_reports     rr
, rg_report_axes rra
WHERE  rr.report_id = pn_cfs_report_id
  AND  rr.ROW_SET_ID = rra.axis_set_id;