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 190: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);

186: G_BALANCING_SEGMENT_LOW VARCHAR2(30); --5336803
187: G_BALANCING_SEGMENT_HIGH VARCHAR2(30); --5336803
188: G_REQUEST_ID NUMBER;
189: g_legal_entity_id NUMBER;
190: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);
191: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);
192: G_GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30); --5336803
193: G_INCLUDE_GL_MANUAL_LINES VARCHAR2(30);--5336803
194: G_CHART_OF_ACCOUNTS_ID NUMBER(15);

Line 191: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);

187: G_BALANCING_SEGMENT_HIGH VARCHAR2(30); --5336803
188: G_REQUEST_ID NUMBER;
189: g_legal_entity_id NUMBER;
190: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);
191: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);
192: G_GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30); --5336803
193: G_INCLUDE_GL_MANUAL_LINES VARCHAR2(30);--5336803
194: G_CHART_OF_ACCOUNTS_ID NUMBER(15);
195: G_REP_CONTEXT_ID NUMBER;

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

188: G_REQUEST_ID NUMBER;
189: g_legal_entity_id NUMBER;
190: G_GDF_GL_JE_LINES_CATEGORY VARCHAR2(150);
191: G_GDF_GL_JE_LINES_ATT3 VARCHAR2(150);
192: G_GDF_GL_JE_LINES_ATT3_IS_NULL VARCHAR2(30); --5336803
193: G_INCLUDE_GL_MANUAL_LINES VARCHAR2(30);--5336803
194: G_CHART_OF_ACCOUNTS_ID NUMBER(15);
195: G_REP_CONTEXT_ID NUMBER;
196: G_LEDGER_ID NUMBER;

Line 322: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;

318: G_BALANCING_SEGMENT_LOW := P_TRL_GLOBAL_VARIABLES_REC.BALANCING_SEGMENT_LOW;
319: G_BALANCING_SEGMENT_HIGH := P_TRL_GLOBAL_VARIABLES_REC.BALANCING_SEGMENT_HIGH;
320: G_LEDGER_ID := P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID;
321: G_INCLUDE_GL_MANUAL_LINES := P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_GL_MANUAL_LINES;
322: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;
323: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;
324: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;
325: -- G_EXTRACT_LINE_NUM := P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_LINE_NUM;
326: g_tax_jurisdiction_code := p_trl_global_variables_rec.tax_jurisdiction_code;

Line 323: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;

319: G_BALANCING_SEGMENT_HIGH := P_TRL_GLOBAL_VARIABLES_REC.BALANCING_SEGMENT_HIGH;
320: G_LEDGER_ID := P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID;
321: G_INCLUDE_GL_MANUAL_LINES := P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_GL_MANUAL_LINES;
322: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;
323: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;
324: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;
325: -- G_EXTRACT_LINE_NUM := P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_LINE_NUM;
326: g_tax_jurisdiction_code := p_trl_global_variables_rec.tax_jurisdiction_code;
327: --g_first_party_tax_reg_num := p_trl_global_variables_rec.first_party_tax_reg_num;

Line 324: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;

320: G_LEDGER_ID := P_TRL_GLOBAL_VARIABLES_REC.LEDGER_ID;
321: G_INCLUDE_GL_MANUAL_LINES := P_TRL_GLOBAL_VARIABLES_REC.INCLUDE_GL_MANUAL_LINES;
322: G_GDF_GL_JE_LINES_CATEGORY := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_CATEGORY;
323: G_GDF_GL_JE_LINES_ATT3 := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3;
324: G_GDF_GL_JE_LINES_ATT3_IS_NULL := P_TRL_GLOBAL_VARIABLES_REC.GDF_GL_JE_LINES_ATT3_IS_NULL;
325: -- G_EXTRACT_LINE_NUM := P_TRL_GLOBAL_VARIABLES_REC.EXTRACT_LINE_NUM;
326: g_tax_jurisdiction_code := p_trl_global_variables_rec.tax_jurisdiction_code;
327: --g_first_party_tax_reg_num := p_trl_global_variables_rec.first_party_tax_reg_num;
328: G_TAX_REGIME_CODE := P_TRL_GLOBAL_VARIABLES_REC.TAX_REGIME_CODE;

Line 755: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN

751: END IF;
752:
753: -- Bugfix 3027941
754:
755: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
756: L_WHERE_GL_LINES_ATT3_IS_NULL :=
757: ' 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';
758: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
759: 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 757: ' 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';

753: -- Bugfix 3027941
754:
755: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
756: L_WHERE_GL_LINES_ATT3_IS_NULL :=
757: ' 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';
758: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
759: 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 ';
760:
761: ELSE

Line 758: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN

754:
755: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
756: L_WHERE_GL_LINES_ATT3_IS_NULL :=
757: ' 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';
758: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
759: 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 ';
760:
761: ELSE
762: 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 759: 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 ';

755: IF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'Y' THEN
756: L_WHERE_GL_LINES_ATT3_IS_NULL :=
757: ' 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';
758: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
759: 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 ';
760:
761: ELSE
762: 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 ';
763: END IF;

Line 762: 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 ';

758: ELSIF G_GDF_GL_JE_LINES_ATT3_IS_NULL = 'N' THEN
759: 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 ';
760:
761: ELSE
762: 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 ';
763: END IF;
764:
765: IF PG_DEBUG = 'Y' THEN
766: arp_util_tax.debug('L_WHERE_GL_LINES_ATT3_IS_NULL = ' || L_WHERE_GL_LINES_ATT3_IS_NULL );

Line 895: gl_je_lines gjl2,

891: ' FROM
892: fnd_document_sequences seq,
893: -- gl_tax_options gto,
894: gl_code_combinations gcc2,
895: gl_je_lines gjl2,
896: -- ar_ap_tax_codes_v tax,
897: zx_rates_vl zx_rate,
898: zx_taxes_vl zx_tax,
899: gl_code_combinations gcc1,

Line 900: gl_je_lines gjl1,

896: -- ar_ap_tax_codes_v tax,
897: zx_rates_vl zx_rate,
898: zx_taxes_vl zx_tax,
899: gl_code_combinations gcc1,
900: gl_je_lines gjl1,
901: gl_je_batches gjb,
902: gl_je_headers gjh,
903: gl_period_statuses gps ';
904:

Line 1107: gl_je_lines gjl2,

1103: ' from
1104: fnd_document_sequences seq,
1105: -- gl_tax_options gto,
1106: gl_code_combinations gcc2,
1107: gl_je_lines gjl2,
1108: --ar_ap_tax_codes_v tax,
1109: zx_rates_vl zx_rate,
1110: zx_taxes_vl zx_tax,
1111: gl_code_combinations gcc1,

Line 1112: gl_je_lines gjl1,

1108: --ar_ap_tax_codes_v tax,
1109: zx_rates_vl zx_rate,
1110: zx_taxes_vl zx_tax,
1111: gl_code_combinations gcc1,
1112: gl_je_lines gjl1,
1113: gl_je_batches gjb,
1114: gl_je_headers gjh,
1115: gl_period_statuses gps ';
1116:

Line 1272: from GL_JE_LINES GJL

1268: p_column_name in varchar2) return number is
1269:
1270: cursor l_denominator_csr(p_tax_group_id in number) is
1271: select sum((nvl(GJL.ENTERED_CR,0)-nvl(GJL.ENTERED_DR,0)))
1272: from GL_JE_LINES GJL
1273: where gjl.je_header_id = p_trx_id and
1274: gjl.tax_group_id = p_tax_group_id and
1275: gjl.tax_code_id is not null;
1276:

Line 1281: from GL_JE_LINES GJL

1277: /* Code added by SSWAYAMP for bug 1742970 */
1278:
1279: cursor l_denominator_csr1(p_tax_group_id in number) is
1280: select SUM(nvl(GJL.ENTERED_CR,0))
1281: from GL_JE_LINES GJL
1282: where gjl.je_header_id = p_trx_id and
1283: gjl.tax_group_id = p_tax_group_id and
1284: gjl.tax_code_id is not null;
1285:

Line 1298: GL_JE_LINES GJL2,

1294: (nvl(GJL2.ACCOUNTED_CR,0)-nvl(GJL2.ACCOUNTED_DR,0)) AAM,
1295: GJL1.TAX_GROUP_ID TAX_GROUP_ID,
1296: (nvl(GJL1.ENTERED_CR,0)-nvl(GJL1.ENTERED_DR,0)) ETAXABLEAM
1297: from FND_DOCUMENT_SEQUENCES SEQ,
1298: GL_JE_LINES GJL2,
1299: -- AR_AP_TAX_CODES_V TAX,
1300: ZX_RATES_VL ZX_RATE,
1301: GL_JE_LINES GJL1,
1302: GL_JE_HEADERS GJH

Line 1301: GL_JE_LINES GJL1,

1297: from FND_DOCUMENT_SEQUENCES SEQ,
1298: GL_JE_LINES GJL2,
1299: -- AR_AP_TAX_CODES_V TAX,
1300: ZX_RATES_VL ZX_RATE,
1301: GL_JE_LINES GJL1,
1302: GL_JE_HEADERS GJH
1303: where gjh.je_header_id = p_trx_id and
1304: gjh.je_header_id = gjl1.je_header_id and
1305: gjl1.tax_code_id = NVL(ZX_RATE.SOURCE_ID,ZX_RATE.TAX_RATE_ID)

Line 1723: 'GL_JE_LINES',

1719: g_last_updated_by,
1720: g_last_update_date,
1721: g_last_update_login,
1722: g_request_id,
1723: 'GL_JE_LINES',
1724: 'MANUAL_JOURNALS',
1725: g_rep_context_id,
1726: g_fun_currency_code,
1727: g_ledger_name );

Line 1958: G_GDF_GL_JE_LINES_CATEGORY,

1954: G_TRX_NUMBER_LOW,
1955: G_TRX_NUMBER_HIGH,
1956: G_TAX_INVOICE_DATE_LOW,
1957: G_TAX_INVOICE_DATE_HIGH,
1958: G_GDF_GL_JE_LINES_CATEGORY,
1959: G_GDF_GL_JE_LINES_ATT3;
1960: -- G_DOCUMENT_SUB_TYPE,
1961: -- G_TRX_BUSINESS_CATEGORY,
1962: -- G_AR_EXEMPTION_STATUS,

Line 1959: G_GDF_GL_JE_LINES_ATT3;

1955: G_TRX_NUMBER_HIGH,
1956: G_TAX_INVOICE_DATE_LOW,
1957: G_TAX_INVOICE_DATE_HIGH,
1958: G_GDF_GL_JE_LINES_CATEGORY,
1959: G_GDF_GL_JE_LINES_ATT3;
1960: -- G_DOCUMENT_SUB_TYPE,
1961: -- G_TRX_BUSINESS_CATEGORY,
1962: -- G_AR_EXEMPTION_STATUS,
1963: -- G_VAT_TAX,

Line 2503: FROM GL_JE_LINES

2499:
2500: CURSOR TAXABLE_ACCT_CURSOR(C_TRX_ID IN NUMBER,
2501: C_TAX_CODE_ID IN NUMBER) IS
2502: SELECT CODE_COMBINATION_ID, TAX_GROUP_ID
2503: FROM GL_JE_LINES
2504: WHERE JE_HEADER_ID = C_TRX_ID
2505: AND TAX_CODE_ID = C_TAX_CODE_ID;
2506:
2507: CURSOR TAX_ACCT_CURSOR(C_TRX_ID IN NUMBER,

Line 2510: FROM GL_JE_LINES

2506:
2507: CURSOR TAX_ACCT_CURSOR(C_TRX_ID IN NUMBER,
2508: C_TAX_GROUP_ID IN NUMBER) IS
2509: SELECT CODE_COMBINATION_ID
2510: FROM GL_JE_LINES
2511: WHERE JE_HEADER_ID = C_TRX_ID
2512: AND TAX_GROUP_ID = C_TAX_GROUP_ID
2513: AND TAX_CODE_ID IS NULL ;
2514:

Line 2517: FROM GL_JE_LINES

2513: AND TAX_CODE_ID IS NULL ;
2514:
2515: CURSOR CONTROL_ACCT_CURSOR(C_TRX_ID IN NUMBER ) IS
2516: SELECT CODE_COMBINATION_ID
2517: FROM GL_JE_LINES
2518: WHERE JE_HEADER_ID = C_TRX_ID
2519: AND TAX_GROUP_ID IS NULL;
2520:
2521: BEGIN