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.ZX_GL_EXTRACT_PKG dependencies on GL_JE_LINES

Line 196: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);

192: G_BALANCING_SEGMENT_LOW VARCHAR2(30); --5336803
193: G_BALANCING_SEGMENT_HIGH VARCHAR2(30); --5336803
194: G_REQUEST_ID NUMBER;
195: g_legal_entity_id NUMBER;
196: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);
197: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);
198: G_GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30); --5336803
199: G_INCLUDE_GL_MANUAL_LINES VARCHAR2(30);--5336803
200: G_CHART_OF_ACCOUNTS_ID NUMBER(15);

Line 197: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);

193: G_BALANCING_SEGMENT_HIGH VARCHAR2(30); --5336803
194: G_REQUEST_ID NUMBER;
195: g_legal_entity_id NUMBER;
196: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);
197: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);
198: G_GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30); --5336803
199: G_INCLUDE_GL_MANUAL_LINES VARCHAR2(30);--5336803
200: G_CHART_OF_ACCOUNTS_ID NUMBER(15);
201: G_REP_CONTEXT_ID NUMBER;

Line 198: G_GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30); --5336803

194: G_REQUEST_ID NUMBER;
195: g_legal_entity_id NUMBER;
196: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);
197: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);
198: G_GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30); --5336803
199: G_INCLUDE_GL_MANUAL_LINES VARCHAR2(30);--5336803
200: G_CHART_OF_ACCOUNTS_ID NUMBER(15);
201: G_REP_CONTEXT_ID NUMBER;
202: G_LEDGER_ID NUMBER;

Line 331: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;

327: G_BALANCING_SEGMENT_LOW := P_TRL_GLOBAL_VARIABLES_REC.BALANCING_SEGMENT_LOW;
328: G_BALANCING_SEGMENT_HIGH := P_TRL_GLOBAL_VARIABLES_REC.BALANCING_SEGMENT_HIGH;
329: G_LEDGER_ID := NVL(P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID, P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID);
330: G_INCLUDE_GL_MANUAL_LINES := P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_GL_MANUAL_LINES;
331: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;
332: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;
333: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;
334: -- G_EXTRACT_LINE_NUM := P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_LINE_NUM;
335: g_tax_jurisdiction_code := p_trl_global_variables_rec.tax_jurisdiction_code;

Line 332: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;

328: G_BALANCING_SEGMENT_HIGH := P_TRL_GLOBAL_VARIABLES_REC.BALANCING_SEGMENT_HIGH;
329: G_LEDGER_ID := NVL(P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID, P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID);
330: G_INCLUDE_GL_MANUAL_LINES := P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_GL_MANUAL_LINES;
331: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;
332: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;
333: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;
334: -- G_EXTRACT_LINE_NUM := P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_LINE_NUM;
335: g_tax_jurisdiction_code := p_trl_global_variables_rec.tax_jurisdiction_code;
336: --g_first_party_tax_reg_num := p_trl_global_variables_rec.first_party_tax_reg_num;

Line 333: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;

329: G_LEDGER_ID := NVL(P_TRL_GLOBAL_VARIABLES_REC.REPORTING_LEDGER_ID, P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID);
330: G_INCLUDE_GL_MANUAL_LINES := P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_GL_MANUAL_LINES;
331: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;
332: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;
333: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;
334: -- G_EXTRACT_LINE_NUM := P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_LINE_NUM;
335: g_tax_jurisdiction_code := p_trl_global_variables_rec.tax_jurisdiction_code;
336: --g_first_party_tax_reg_num := p_trl_global_variables_rec.first_party_tax_reg_num;
337: G_TAX_REGIME_CODE := P_TRL_GLOBAL_VARIABLES_REC.TAX_REGIME_CODE;

Line 767: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN

763:
764: ***/
765: -- Bugfix 3027941
766:
767: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
768: L_WHERE_GL_LINES_ATT3_IS_NULL :=
769: ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null and GJL1.GLOBAL_ATTRIBUTE3 IS NULL';
770: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
771: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND GJL1.GLOBAL_ATTRIBUTE_CATEGORY = :G_GDF_GL_JE_LINES_CATEGORY AND GJL1.GLOBAL_ATTRIBUTE3 = :G_GDF_GL_JE_LINES_ATT3 ';

Line 769: ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null and GJL1.GLOBAL_ATTRIBUTE3 IS NULL';

765: -- Bugfix 3027941
766:
767: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
768: L_WHERE_GL_LINES_ATT3_IS_NULL :=
769: ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null and GJL1.GLOBAL_ATTRIBUTE3 IS NULL';
770: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
771: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND GJL1.GLOBAL_ATTRIBUTE_CATEGORY = :G_GDF_GL_JE_LINES_CATEGORY AND GJL1.GLOBAL_ATTRIBUTE3 = :G_GDF_GL_JE_LINES_ATT3 ';
772:
773: ELSE

Line 770: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN

766:
767: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
768: L_WHERE_GL_LINES_ATT3_IS_NULL :=
769: ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null and GJL1.GLOBAL_ATTRIBUTE3 IS NULL';
770: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
771: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND GJL1.GLOBAL_ATTRIBUTE_CATEGORY = :G_GDF_GL_JE_LINES_CATEGORY AND GJL1.GLOBAL_ATTRIBUTE3 = :G_GDF_GL_JE_LINES_ATT3 ';
772:
773: ELSE
774: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null ';

Line 771: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND GJL1.GLOBAL_ATTRIBUTE_CATEGORY = :G_GDF_GL_JE_LINES_CATEGORY AND GJL1.GLOBAL_ATTRIBUTE3 = :G_GDF_GL_JE_LINES_ATT3 ';

767: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
768: L_WHERE_GL_LINES_ATT3_IS_NULL :=
769: ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null and GJL1.GLOBAL_ATTRIBUTE3 IS NULL';
770: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
771: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND GJL1.GLOBAL_ATTRIBUTE_CATEGORY = :G_GDF_GL_JE_LINES_CATEGORY AND GJL1.GLOBAL_ATTRIBUTE3 = :G_GDF_GL_JE_LINES_ATT3 ';
772:
773: ELSE
774: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null ';
775: END IF;

Line 774: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null ';

770: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
771: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND GJL1.GLOBAL_ATTRIBUTE_CATEGORY = :G_GDF_GL_JE_LINES_CATEGORY AND GJL1.GLOBAL_ATTRIBUTE3 = :G_GDF_GL_JE_LINES_ATT3 ';
772:
773: ELSE
774: L_WHERE_GL_LINES_ATT3_IS_NULL := ' AND decode(:G_GDF_GL_JE_LINES_CATEGORY,NULL,NULL) is null and decode (:G_GDF_GL_JE_LINES_ATT3,NULL,NULL) is null ';
775: END IF;
776:
777: IF PG_DEBUG = 'Y' THEN
778: arp_util_tax.debug('L_WHERE_GL_LINES_ATT3_IS_NULL = ' || L_WHERE_GL_LINES_ATT3_IS_NULL );

Line 908: gl_je_lines gjl2,

904: ' FROM
905: fnd_document_sequences seq,
906: -- gl_tax_options gto,
907: gl_code_combinations gcc2,
908: gl_je_lines gjl2,
909: -- ar_ap_tax_codes_v tax,
910: zx_rates_vl zx_rate,
911: zx_taxes_vl zx_tax,
912: gl_code_combinations gcc1,

Line 913: gl_je_lines gjl1,

909: -- ar_ap_tax_codes_v tax,
910: zx_rates_vl zx_rate,
911: zx_taxes_vl zx_tax,
912: gl_code_combinations gcc1,
913: gl_je_lines gjl1,
914: gl_je_batches gjb,
915: gl_je_headers gjh,
916: gl_period_statuses gps ';
917:

Line 1122: gl_je_lines gjl2,

1118: ' from
1119: fnd_document_sequences seq,
1120: -- gl_tax_options gto,
1121: gl_code_combinations gcc2,
1122: gl_je_lines gjl2,
1123: --ar_ap_tax_codes_v tax,
1124: zx_rates_vl zx_rate,
1125: zx_taxes_vl zx_tax,
1126: gl_code_combinations gcc1,

Line 1127: gl_je_lines gjl1,

1123: --ar_ap_tax_codes_v tax,
1124: zx_rates_vl zx_rate,
1125: zx_taxes_vl zx_tax,
1126: gl_code_combinations gcc1,
1127: gl_je_lines gjl1,
1128: gl_je_batches gjb,
1129: gl_je_headers gjh,
1130: gl_period_statuses gps ';
1131:

Line 1288: from GL_JE_LINES GJL

1284: p_column_name in varchar2) return number is
1285:
1286: cursor l_denominator_csr(p_tax_group_id in number) is
1287: select sum((nvl(GJL.ENTERED_CR,0)-nvl(GJL.ENTERED_DR,0)))
1288: from GL_JE_LINES GJL
1289: where gjl.je_header_id = p_trx_id and
1290: gjl.tax_group_id = p_tax_group_id and
1291: gjl.tax_code_id is not null;
1292:

Line 1297: from GL_JE_LINES GJL

1293: /* Code added by SSWAYAMP for bug 1742970 */
1294:
1295: cursor l_denominator_csr1(p_tax_group_id in number) is
1296: select SUM(nvl(GJL.ENTERED_CR,0))
1297: from GL_JE_LINES GJL
1298: where gjl.je_header_id = p_trx_id and
1299: gjl.tax_group_id = p_tax_group_id and
1300: gjl.tax_code_id is not null;
1301:

Line 1314: GL_JE_LINES GJL2,

1310: (nvl(GJL2.ACCOUNTED_CR,0)-nvl(GJL2.ACCOUNTED_DR,0)) AAM,
1311: GJL1.TAX_GROUP_ID TAX_GROUP_ID,
1312: (nvl(GJL1.ENTERED_CR,0)-nvl(GJL1.ENTERED_DR,0)) ETAXABLEAM
1313: from FND_DOCUMENT_SEQUENCES SEQ,
1314: GL_JE_LINES GJL2,
1315: -- AR_AP_TAX_CODES_V TAX,
1316: ZX_RATES_VL ZX_RATE,
1317: GL_JE_LINES GJL1,
1318: GL_JE_HEADERS GJH

Line 1317: GL_JE_LINES GJL1,

1313: from FND_DOCUMENT_SEQUENCES SEQ,
1314: GL_JE_LINES GJL2,
1315: -- AR_AP_TAX_CODES_V TAX,
1316: ZX_RATES_VL ZX_RATE,
1317: GL_JE_LINES GJL1,
1318: GL_JE_HEADERS GJH
1319: where gjh.je_header_id = p_trx_id and
1320: gjh.je_header_id = gjl1.je_header_id and
1321: gjl1.tax_code_id = NVL(ZX_RATE.SOURCE_ID,ZX_RATE.TAX_RATE_ID)

Line 1741: 'GL_JE_LINES',

1737: g_last_updated_by,
1738: g_last_update_date,
1739: g_last_update_login,
1740: g_request_id,
1741: 'GL_JE_LINES',
1742: 'MANUAL_JOURNALS',
1743: g_rep_context_id,
1744: g_fun_currency_code,
1745: g_ledger_name );

Line 1978: G_GDF_GL_JE_LINES_CATEGORY,

1974: G_TRX_NUMBER_LOW,
1975: G_TRX_NUMBER_HIGH,
1976: G_TAX_INVOICE_DATE_LOW,
1977: G_TAX_INVOICE_DATE_HIGH,
1978: G_GDF_GL_JE_LINES_CATEGORY,
1979: G_GDF_GL_JE_LINES_ATT3;
1980: -- G_DOCUMENT_SUB_TYPE,
1981: -- G_TRX_BUSINESS_CATEGORY,
1982: -- G_AR_EXEMPTION_STATUS,

Line 1979: G_GDF_GL_JE_LINES_ATT3;

1975: G_TRX_NUMBER_HIGH,
1976: G_TAX_INVOICE_DATE_LOW,
1977: G_TAX_INVOICE_DATE_HIGH,
1978: G_GDF_GL_JE_LINES_CATEGORY,
1979: G_GDF_GL_JE_LINES_ATT3;
1980: -- G_DOCUMENT_SUB_TYPE,
1981: -- G_TRX_BUSINESS_CATEGORY,
1982: -- G_AR_EXEMPTION_STATUS,
1983: -- G_VAT_TAX,

Line 2557: FROM GL_JE_LINES

2553: CURSOR TAXABLE_ACCT_CURSOR(C_TRX_ID IN NUMBER,
2554: C_TAX_CODE_ID IN NUMBER,
2555: C_TRX_LINE_ID IN NUMBER) IS
2556: SELECT CODE_COMBINATION_ID, TAX_GROUP_ID
2557: FROM GL_JE_LINES
2558: WHERE JE_HEADER_ID = C_TRX_ID
2559: AND TAX_CODE_ID = C_TAX_CODE_ID
2560: AND JE_LINE_NUM = C_TRX_LINE_ID;
2561:

Line 2566: FROM GL_JE_LINES

2562: CURSOR TAX_ACCT_CURSOR(C_TRX_ID IN NUMBER,
2563: C_TAX_GROUP_ID IN NUMBER,
2564: C_TRX_LINE_ID IN NUMBER) IS
2565: SELECT CODE_COMBINATION_ID
2566: FROM GL_JE_LINES
2567: WHERE JE_HEADER_ID = C_TRX_ID
2568: AND TAX_GROUP_ID = C_TAX_GROUP_ID
2569: AND TAX_CODE_ID IS NULL
2570: AND JE_LINE_NUM = C_TRX_LINE_ID;

Line 2575: FROM GL_JE_LINES

2571:
2572: CURSOR CONTROL_ACCT_CURSOR(C_TRX_ID IN NUMBER,
2573: C_TRX_LINE_ID IN NUMBER) IS
2574: SELECT CODE_COMBINATION_ID
2575: FROM GL_JE_LINES
2576: WHERE JE_HEADER_ID = C_TRX_ID
2577: AND TAX_GROUP_ID IS NULL
2578: AND JE_LINE_NUM = C_TRX_LINE_ID;
2579: