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_COA_EXP_PKG dependencies on JA_CN_DFF_ASSIGNMENTS

Line 97: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;

93: ,P_COA_ID IN NUMBER ) IS
94: l_ledger_id NUMBER := P_LEDGER_ID;
95: l_coa_id NUMBER := P_COA_ID;
96: l_sql_str varchar2(30000):='';
97: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
98: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 98: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;

94: l_ledger_id NUMBER := P_LEDGER_ID;
95: l_coa_id NUMBER := P_COA_ID;
96: l_sql_str varchar2(30000):='';
97: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
98: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;

95: l_coa_id NUMBER := P_COA_ID;
96: l_sql_str varchar2(30000):='';
97: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
98: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

96: l_sql_str varchar2(30000):='';
97: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
98: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
104: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

97: l_acc_level_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
98: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
104: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
105: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

Line 102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

98: l_acc_sub_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
104: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
105: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
106:

Line 103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

99: l_acc_bal_context JA_CN_DFF_ASSIGNMENTS.CONTEXT_CODE%TYPE;
100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
104: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
105: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
106:
107: BEGIN

Line 104: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

100: l_acc_level_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
104: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
105: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
106:
107: BEGIN
108: --Get positions of

Line 105: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;

101: l_sub_pj_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
102: l_sub_tp_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
103: l_sub_cc_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
104: l_sub_person_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
105: l_acc_bal_position JA_CN_DFF_ASSIGNMENTS.ATTRIBUTE_COLUMN%TYPE;
106:
107: BEGIN
108: --Get positions of
109: -- account level, project, third party, cost center and personnel,and Balance Side

Line 129: FROM JA_CN_DFF_ASSIGNMENTS DFF1

125: ,l_sub_tp_position
126: ,l_sub_cc_position
127: ,l_sub_person_position
128: ,l_acc_bal_position
129: FROM JA_CN_DFF_ASSIGNMENTS DFF1
130: ,JA_CN_DFF_ASSIGNMENTS DFF2
131: ,JA_CN_DFF_ASSIGNMENTS DFF3
132: ,JA_CN_DFF_ASSIGNMENTS DFF4
133: ,JA_CN_DFF_ASSIGNMENTS DFF5

Line 130: ,JA_CN_DFF_ASSIGNMENTS DFF2

126: ,l_sub_cc_position
127: ,l_sub_person_position
128: ,l_acc_bal_position
129: FROM JA_CN_DFF_ASSIGNMENTS DFF1
130: ,JA_CN_DFF_ASSIGNMENTS DFF2
131: ,JA_CN_DFF_ASSIGNMENTS DFF3
132: ,JA_CN_DFF_ASSIGNMENTS DFF4
133: ,JA_CN_DFF_ASSIGNMENTS DFF5
134: ,JA_CN_DFF_ASSIGNMENTS DFF6

Line 131: ,JA_CN_DFF_ASSIGNMENTS DFF3

127: ,l_sub_person_position
128: ,l_acc_bal_position
129: FROM JA_CN_DFF_ASSIGNMENTS DFF1
130: ,JA_CN_DFF_ASSIGNMENTS DFF2
131: ,JA_CN_DFF_ASSIGNMENTS DFF3
132: ,JA_CN_DFF_ASSIGNMENTS DFF4
133: ,JA_CN_DFF_ASSIGNMENTS DFF5
134: ,JA_CN_DFF_ASSIGNMENTS DFF6
135: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level

Line 132: ,JA_CN_DFF_ASSIGNMENTS DFF4

128: ,l_acc_bal_position
129: FROM JA_CN_DFF_ASSIGNMENTS DFF1
130: ,JA_CN_DFF_ASSIGNMENTS DFF2
131: ,JA_CN_DFF_ASSIGNMENTS DFF3
132: ,JA_CN_DFF_ASSIGNMENTS DFF4
133: ,JA_CN_DFF_ASSIGNMENTS DFF5
134: ,JA_CN_DFF_ASSIGNMENTS DFF6
135: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
136: AND DFF2.DFF_TITLE_CODE = 'SAPA' -- Project

Line 133: ,JA_CN_DFF_ASSIGNMENTS DFF5

129: FROM JA_CN_DFF_ASSIGNMENTS DFF1
130: ,JA_CN_DFF_ASSIGNMENTS DFF2
131: ,JA_CN_DFF_ASSIGNMENTS DFF3
132: ,JA_CN_DFF_ASSIGNMENTS DFF4
133: ,JA_CN_DFF_ASSIGNMENTS DFF5
134: ,JA_CN_DFF_ASSIGNMENTS DFF6
135: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
136: AND DFF2.DFF_TITLE_CODE = 'SAPA' -- Project
137: AND DFF3.DFF_TITLE_CODE = 'SATP' -- Third party

Line 134: ,JA_CN_DFF_ASSIGNMENTS DFF6

130: ,JA_CN_DFF_ASSIGNMENTS DFF2
131: ,JA_CN_DFF_ASSIGNMENTS DFF3
132: ,JA_CN_DFF_ASSIGNMENTS DFF4
133: ,JA_CN_DFF_ASSIGNMENTS DFF5
134: ,JA_CN_DFF_ASSIGNMENTS DFF6
135: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
136: AND DFF2.DFF_TITLE_CODE = 'SAPA' -- Project
137: AND DFF3.DFF_TITLE_CODE = 'SATP' -- Third party
138: AND DFF4.DFF_TITLE_CODE = 'SACC' -- Cost center

Line 518: FROM JA_CN_DFF_ASSIGNMENTS DFF1

514: DECODE(nvl(DFF5.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
515: || DECODE(nvl(DFF6.CONTEXT_CODE, ''), '', 'N',
516: DECODE(nvl(DFF6.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
517: dff_assign
518: FROM JA_CN_DFF_ASSIGNMENTS DFF1
519: ,JA_CN_DFF_ASSIGNMENTS DFF2
520: ,JA_CN_DFF_ASSIGNMENTS DFF3
521: ,JA_CN_DFF_ASSIGNMENTS DFF4
522: ,JA_CN_DFF_ASSIGNMENTS DFF5

Line 519: ,JA_CN_DFF_ASSIGNMENTS DFF2

515: || DECODE(nvl(DFF6.CONTEXT_CODE, ''), '', 'N',
516: DECODE(nvl(DFF6.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
517: dff_assign
518: FROM JA_CN_DFF_ASSIGNMENTS DFF1
519: ,JA_CN_DFF_ASSIGNMENTS DFF2
520: ,JA_CN_DFF_ASSIGNMENTS DFF3
521: ,JA_CN_DFF_ASSIGNMENTS DFF4
522: ,JA_CN_DFF_ASSIGNMENTS DFF5
523: ,JA_CN_DFF_ASSIGNMENTS DFF6

Line 520: ,JA_CN_DFF_ASSIGNMENTS DFF3

516: DECODE(nvl(DFF6.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
517: dff_assign
518: FROM JA_CN_DFF_ASSIGNMENTS DFF1
519: ,JA_CN_DFF_ASSIGNMENTS DFF2
520: ,JA_CN_DFF_ASSIGNMENTS DFF3
521: ,JA_CN_DFF_ASSIGNMENTS DFF4
522: ,JA_CN_DFF_ASSIGNMENTS DFF5
523: ,JA_CN_DFF_ASSIGNMENTS DFF6
524: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level

Line 521: ,JA_CN_DFF_ASSIGNMENTS DFF4

517: dff_assign
518: FROM JA_CN_DFF_ASSIGNMENTS DFF1
519: ,JA_CN_DFF_ASSIGNMENTS DFF2
520: ,JA_CN_DFF_ASSIGNMENTS DFF3
521: ,JA_CN_DFF_ASSIGNMENTS DFF4
522: ,JA_CN_DFF_ASSIGNMENTS DFF5
523: ,JA_CN_DFF_ASSIGNMENTS DFF6
524: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
525: AND DFF2.DFF_TITLE_CODE = 'SAPA' -- Project

Line 522: ,JA_CN_DFF_ASSIGNMENTS DFF5

518: FROM JA_CN_DFF_ASSIGNMENTS DFF1
519: ,JA_CN_DFF_ASSIGNMENTS DFF2
520: ,JA_CN_DFF_ASSIGNMENTS DFF3
521: ,JA_CN_DFF_ASSIGNMENTS DFF4
522: ,JA_CN_DFF_ASSIGNMENTS DFF5
523: ,JA_CN_DFF_ASSIGNMENTS DFF6
524: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
525: AND DFF2.DFF_TITLE_CODE = 'SAPA' -- Project
526: AND DFF3.DFF_TITLE_CODE = 'SATP' -- Third party

Line 523: ,JA_CN_DFF_ASSIGNMENTS DFF6

519: ,JA_CN_DFF_ASSIGNMENTS DFF2
520: ,JA_CN_DFF_ASSIGNMENTS DFF3
521: ,JA_CN_DFF_ASSIGNMENTS DFF4
522: ,JA_CN_DFF_ASSIGNMENTS DFF5
523: ,JA_CN_DFF_ASSIGNMENTS DFF6
524: WHERE DFF1.DFF_TITLE_CODE = 'ACLE' -- Account Level
525: AND DFF2.DFF_TITLE_CODE = 'SAPA' -- Project
526: AND DFF3.DFF_TITLE_CODE = 'SATP' -- Third party
527: AND DFF4.DFF_TITLE_CODE = 'SACC' -- Cost center