APPS.ZX_JE_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 167: FROM zx_rep_trx_detail_t itf1

163: AND itf1.TAX_RATE_ID = assoc.entity_id
164: AND assoc.entity_code = 'ZX_RATES'
165: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)
166: AND rep_type.reporting_type_code= 'EMEA_VAT_REPORTING_TYPE')
167: FROM zx_rep_trx_detail_t itf1
168: WHERE itf1.application_id = 222
169: AND itf1.entity_code = 'TRANSACTIONS'
170: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
171:

Line 194: FROM zx_rep_trx_detail_t itf1

190: END IF;
191:
192: SELECT detail_tax_line_id
193: BULK COLLECT INTO l_detail_tax_line_id_tbl
194: FROM zx_rep_trx_detail_t itf1
195: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
196:
197:
198: IF l_detail_tax_line_id_tbl.count <> 0 THEN

Line 241: zx_rep_trx_detail_t itf1

237: sysdate,
238: fnd_global.login_id,
239: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
240: FROM ra_customer_trx_all ra_cust,
241: zx_rep_trx_detail_t itf1
242: WHERE itf1.trx_id = ra_cust.customer_trx_id
243: AND itf1.application_id = 222
244: AND itf1.entity_code = 'TRANSACTIONS'
245: AND itf1.ledger_id = ra_cust.set_of_books_id

Line 624: zx_rep_trx_detail_t itf1

620: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)
621: AND rep_type.reporting_type_code= 'EMEA_VAT_REPORTING_TYPE')
622: FROM financials_system_params_all fsp,
623: hr_locations_all hr_loc,
624: zx_rep_trx_detail_t itf1
625: WHERE
626: itf1.application_id = 200
627: AND itf1.entity_code = 'AP_INVOICES'
628: AND itf1.ledger_id = fsp.set_of_books_id

Line 654: FROM zx_rep_trx_detail_t itf1

650:
651:
652: SELECT detail_tax_line_id
653: BULK COLLECT INTO l_tax_line_id_tbl
654: FROM zx_rep_trx_detail_t itf1
655: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
656:
657:
658: IF l_tax_line_id_tbl.count <> 0 THEN

Line 726: zx_rep_trx_detail_t itf1

722: sysdate,
723: fnd_global.login_id,
724: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
725: FROM ap_invoices_all ap_inv,
726: zx_rep_trx_detail_t itf1
727: WHERE itf1.trx_id = ap_inv.invoice_id
728: and itf1.application_id = 200
729: and itf1.entity_code = 'AP_INVOICES'
730: and itf1.ledger_id = ap_inv.set_of_books_id

Line 1062: FROM zx_rep_trx_detail_t itf1

1058: AND itf1.TAX_RATE_ID = assoc.entity_id
1059: AND assoc.entity_code = 'ZX_RATES'
1060: AND (assoc.EFFECTIVE_TO is null or assoc.EFFECTIVE_TO > sysdate)
1061: AND rep_type.reporting_type_code= 'EMEA_VAT_REPORTING_TYPE')
1062: FROM zx_rep_trx_detail_t itf1
1063: WHERE itf1.application_id = 101
1064: AND itf1.entity_code = 'GL_JE_LINES'
1065: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1066:

Line 1082: FROM zx_rep_trx_detail_t itf1

1078: END IF;
1079:
1080: SELECT detail_tax_line_id
1081: BULK COLLECT INTO l_detail_tax_line_id_tbl
1082: FROM zx_rep_trx_detail_t itf1
1083: WHERE itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID;
1084:
1085: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1086: FND_LOG.STRING(g_level_unexpected,

Line 1113: zx_rep_trx_detail_t itf1

1109: fnd_global.login_id,
1110: gjl.tax_type_code,
1111: P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1112: FROM gl_je_lines gjl ,
1113: zx_rep_trx_detail_t itf1
1114: WHERE itf1.application_id = 101
1115: AND itf1.request_id = P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID
1116: AND itf1.trx_id = gjl.je_header_id
1117: AND itf1.trx_line_id = gjl.je_line_num;