eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_CFS_CALCULATE_PKG dependencies on JA_CN_CFS_CALCULATIONS_GT

Line 398: ,ja_cn_cfs_calculations_gt ccg

394: SELECT
395: count(DISTINCT ccg.axis_seq)
396: FROM
397: ja_cn_cfs_row_cgs_gt crcg
398: ,ja_cn_cfs_calculations_gt ccg
399: WHERE crcg.application_id=l_application_id
400: AND crcg.axis_set_id=l_axis_set_id
401: AND (crcg.type IS NULL) OR (crcg.type<>'E')
402: AND ccg.application_id=crcg.application_id

Line 413: ,ja_cn_cfs_calculations_gt ccg

409: SELECT
410: DISTINCT ccg.axis_seq
411: FROM
412: ja_cn_cfs_row_cgs_gt crcg
413: ,ja_cn_cfs_calculations_gt ccg
414: WHERE crcg.application_id=l_application_id
415: AND crcg.axis_set_id=l_axis_set_id
416: AND (crcg.type IS NULL) OR (crcg.type<>'E')
417: AND ccg.application_id=crcg.application_id

Line 430: ja_cn_cfs_calculations_gt

426: ,operator_flag
427: ,cal_axis_seq
428: ,constant
429: FROM
430: ja_cn_cfs_calculations_gt
431: WHERE application_id=l_application_id
432: AND axis_set_id=l_axis_set_id
433: AND axis_seq=l_calculated_axis_seq
434: AND cal_axis_seq=l_cal_axis_seq

Line 528: ja_cn_cfs_calculations_gt

524:
525:
526: INSERT
527: INTO
528: ja_cn_cfs_calculations_gt
529: (application_id,axis_set_id
530: ,axis_seq
531: ,calculation_seq
532: ,operator

Line 551: FROM ja_cn_cfs_calculations_gt;

547:
548: -----------FOR TEST--------------------
549: SELECT COUNT(*)
550: INTO L_GT_COUNTS
551: FROM ja_cn_cfs_calculations_gt;
552: ---------------------------------------
553: l_calculation_seq:=l_calculation_seq+1;
554: FETCH c_axis_seqs_per_line INTO l_cal_axis_seq;
555: END LOOP;

Line 570: ja_cn_cfs_calculations_gt

566: CLOSE c_axis_seq;
567:
568: INSERT
569: INTO
570: ja_cn_cfs_calculations_gt
571: (application_id,axis_set_id
572: ,axis_seq
573: ,calculation_seq
574: ,operator

Line 599: ja_cn_cfs_calculations_gt

595:
596:
597: INSERT
598: INTO
599: ja_cn_cfs_calculations_gt
600: (application_id,axis_set_id
601: ,axis_seq
602: ,calculation_seq
603: ,operator

Line 699: ja_cn_cfs_calculations_gt ccg

695: AND (crcg.type IS NULL OR crcg.type<>'E')
696: AND crcg.axis_seq IN (SELECT
697: DISTINCT ccg.axis_seq
698: FROM
699: ja_cn_cfs_calculations_gt ccg
700: WHERE ccg.application_id=crcg.application_id
701: AND ccg.axis_set_id=crcg.axis_set_id
702: AND ccg.cal_axis_seq=l_cal_axis_seq
703: );

Line 722: ja_cn_cfs_calculations_gt

718:
719: --Decompose current row number
720: INSERT
721: INTO
722: ja_cn_cfs_calculations_gt
723: (application_id,axis_set_id
724: ,axis_seq
725: ,calculation_seq
726: ,operator

Line 747: ja_cn_cfs_calculations_gt

743: ,l_cal_line.operator_flag*operator_flag
744: ,cal_axis_seq
745: ,constant
746: FROM
747: ja_cn_cfs_calculations_gt
748: WHERE application_id=l_application_id
749: AND axis_set_id=l_axis_set_id
750: AND axis_seq=l_cal_axis_seq;
751:

Line 760: ja_cn_cfs_calculations_gt

756: --of row l_calculated_axis_seq
757: --
758: DELETE
759: FROM
760: ja_cn_cfs_calculations_gt
761: WHERE application_id=l_application_id
762: AND axis_set_id=l_axis_set_id
763: AND axis_seq=l_calculated_axis_seq
764: AND cal_axis_seq=l_cal_axis_seq;

Line 795: FROM ja_cn_cfs_calculations_gt;

791:
792: -----------FOR TEST--------------------
793: SELECT COUNT(*)
794: INTO L_GT_COUNTS
795: FROM ja_cn_cfs_calculations_gt;
796: ---------------------------------------
797:
798:
799:

Line 1092: ,ja_cn_cfs_calculations_gt ccg

1088: INTO
1089: l_cal_type
1090: FROM
1091: ja_cn_cfs_row_cgs_gt crcg
1092: ,ja_cn_cfs_calculations_gt ccg
1093: WHERE ccg.application_id=l_cal_axis_seq.application_id
1094: AND ccg.axis_set_id=l_axis_set_id
1095: AND ccg.axis_seq=l_cal_axis_seq.axis_seq
1096: AND crcg.application_id=ccg.application_id

Line 1521: ja_cn_cfs_calculations_gt

1517: operator
1518: ,cal_axis_seq
1519: ,constant
1520: FROM
1521: ja_cn_cfs_calculations_gt
1522: WHERE axis_set_id=l_axis_set_id
1523: AND axis_seq=l_axis_seq
1524: ORDER BY calculation_seq;
1525:

Line 1870: ja_cn_cfs_calculations_gt jcccg

1866: jcccg.operator
1867: ,jccrcg.lincnt
1868: ,jccrcg.change_sign_flag
1869: FROM
1870: ja_cn_cfs_calculations_gt jcccg
1871: ,ja_cn_cfs_row_cgs_gt jccrcg
1872: WHERE jcccg.axis_set_id=l_axis_set_id
1873: AND jcccg.axis_seq=l_axis_seq
1874: AND jcccg.axis_set_id=jccrcg.axis_set_id