APPS.JA_CN_CFS_REPORT_PKG dependencies on RG_REPORT_AXES

Line 495: --L_ROW_NAME RG_REPORT_AXES.AXIS_NAME%TYPE;

491: L_THIRD_PARTY_NUMBER varchar2(100);
492: L_REFERENCE_NUMBER JA_CN_CFS_ACTIVITIES_ALL.REFERENCE_NUMBER%TYPE;
493: L_SOURCE JA_CN_CFS_ACTIVITIES_ALL.SOURCE%TYPE;
494: -- Fix bug#6751696 delete begin
495: --L_ROW_NAME RG_REPORT_AXES.AXIS_NAME%TYPE;
496: -- Fix bug#6751696 delete end
497: -- Fix bug#6751696 add begin
498: L_ROW_NAME RG_REPORT_AXES.AXIS_SEQ%TYPE;
499: -- Fix bug#6751696 add end

Line 498: L_ROW_NAME RG_REPORT_AXES.AXIS_SEQ%TYPE;

494: -- Fix bug#6751696 delete begin
495: --L_ROW_NAME RG_REPORT_AXES.AXIS_NAME%TYPE;
496: -- Fix bug#6751696 delete end
497: -- Fix bug#6751696 add begin
498: L_ROW_NAME RG_REPORT_AXES.AXIS_SEQ%TYPE;
499: -- Fix bug#6751696 add end
500: L_ROW_DESCRIPTION RG_REPORT_AXES.DESCRIPTION%TYPE;
501: L_REPORT_NAME RG_REPORTS.NAME%TYPE;
502: L_LEDGER_NAME VARCHAR2(30);

Line 500: L_ROW_DESCRIPTION RG_REPORT_AXES.DESCRIPTION%TYPE;

496: -- Fix bug#6751696 delete end
497: -- Fix bug#6751696 add begin
498: L_ROW_NAME RG_REPORT_AXES.AXIS_SEQ%TYPE;
499: -- Fix bug#6751696 add end
500: L_ROW_DESCRIPTION RG_REPORT_AXES.DESCRIPTION%TYPE;
501: L_REPORT_NAME RG_REPORTS.NAME%TYPE;
502: L_LEDGER_NAME VARCHAR2(30);
503: L_INTERCOMPANY_FLAG JA_CN_CFS_ACTIVITIES_ALL.INTERCOMPANY_FLAG%TYPE;
504: L_TRANSACTION_TYPE JA_CN_CFS_ACTIVITIES_ALL.TRANSACTION_TYPE%TYPE;

Line 550: ,RG_REPORT_AXES RRA

546: SELECT DISTINCT JCA.PERIOD_NAME
547: ,GP.PERIOD_NUM
548: FROM JA_CN_CFS_ACTIVITIES_ALL JCA
549: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
550: ,RG_REPORT_AXES RRA
551: ,RG_REPORTS RG
552: ,GL_LEDGERS LED
553: ,GL_PERIODS GP
554: WHERE JCA.LEGAL_ENTITY_ID = P_LE_ID

Line 593: ,RG_REPORT_AXES RRA

589: RRA.AXIS_SEQ
590: -- Fix bug#6751696 add end
591: FROM JA_CN_CFS_ACTIVITIES_ALL JCA
592: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
593: ,RG_REPORT_AXES RRA
594: ,RG_REPORTS RG
595: WHERE JCA.LEGAL_ENTITY_ID = P_LE_ID
596: AND JCA.PERIOD_NAME = P_PERIOD_NAME
597: AND JCCA.DETAILED_CFS_ITEM = JCA.DETAILED_CFS_ITEM

Line 650: ,RG_REPORT_AXES RRA

646: ,JCA.Balancing_Segment--enhancment add
647: FROM JA_CN_CFS_ACTIVITIES_ALL JCA
648: ,JA_CN_CFS_ASSIGNMENTS_ALL JCCA
649: ,RG_REPORTS RG
650: ,RG_REPORT_AXES RRA
651: WHERE JCA.LEGAL_ENTITY_ID = P_LE_ID
652: AND JCA.PERIOD_NAME = P_PERIOD_NAME
653: AND JCA.SOURCE = NVL(P_SOURCE,
654: JCA.SOURCE)