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.JE_ZZ_AUDIT_AP_PKG dependencies on ZX_LINES

Line 128: ,zx_lines zl

124: ,ap_invoice_distributions ppdis
125: ,ap_checks chk
126: ,ap_invoice_payments aip
127: ,ap_invoice_lines apl
128: ,zx_lines zl
129: ,zx_lines_det_factors zldf
130: WHERE ( ( P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID )
131: OR ( P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID )
132: OR ( P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID

Line 129: ,zx_lines_det_factors zldf

125: ,ap_checks chk
126: ,ap_invoice_payments aip
127: ,ap_invoice_lines apl
128: ,zx_lines zl
129: ,zx_lines_det_factors zldf
130: WHERE ( ( P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID )
131: OR ( P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID )
132: OR ( P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID
133: and get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY) )

Line 260: FROM zx_lines zx_line

256: ,xla_head.ae_header_id
257: ,xla_line.code_combination_id
258: ,xla_head.period_name
259: ,zx_dist.rec_nrec_tax_dist_id
260: FROM zx_lines zx_line
261: ,zx_lines_det_factors zx_det
262: ,zx_rec_nrec_dist zx_dist
263: ,zx_taxes_vl zx_tax
264: ,zx_rates_vl zx_rate

Line 261: ,zx_lines_det_factors zx_det

257: ,xla_line.code_combination_id
258: ,xla_head.period_name
259: ,zx_dist.rec_nrec_tax_dist_id
260: FROM zx_lines zx_line
261: ,zx_lines_det_factors zx_det
262: ,zx_rec_nrec_dist zx_dist
263: ,zx_taxes_vl zx_tax
264: ,zx_rates_vl zx_rate
265: ,xla_transaction_entities xla_ent

Line 314: FROM zx_lines zx_line

310: ,xla_head.ae_header_id
311: ,xla_line.code_combination_id
312: ,xla_head.period_name
313: ,zx_dist.rec_nrec_tax_dist_id
314: FROM zx_lines zx_line
315: ,zx_lines_det_factors zx_det
316: ,zx_rec_nrec_dist zx_dist
317: ,zx_taxes_vl zx_tax
318: ,zx_rates_vl zx_rate

Line 315: ,zx_lines_det_factors zx_det

311: ,xla_line.code_combination_id
312: ,xla_head.period_name
313: ,zx_dist.rec_nrec_tax_dist_id
314: FROM zx_lines zx_line
315: ,zx_lines_det_factors zx_det
316: ,zx_rec_nrec_dist zx_dist
317: ,zx_taxes_vl zx_tax
318: ,zx_rates_vl zx_rate
319: ,xla_transaction_entities xla_ent

Line 684: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf

680: AND dis.line_type_lookup_code <> 'PREPAY'
681: AND zl.trx_line_dist_id = dis.invoice_distribution_id
682: AND dis.match_status_flag IS NOT NULL
683: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
684: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf
685: WHERE SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'DEB/M'
686: AND zldf.trx_id = inv.invoice_id )
687: GROUP BY zl.trx_line_dist_id,
688: tax.tax_rate_id,

Line 781: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf

777: AND dis.line_type_lookup_code = 'PREPAY'
778: AND zl.trx_line_dist_id = dis.invoice_distribution_id
779: AND dis.match_status_flag IS NOT NULL
780: AND (dis.accounting_date BETWEEN l_start_date AND l_end_date)
781: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf
782: WHERE SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'DEB/M'
783: AND zldf.trx_id = inv.invoice_id )
784: GROUP BY zl.trx_line_dist_id,
785: tax.tax_rate_id,

Line 886: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

882: AND dis.line_type_lookup_code <> 'PREPAY'
883: AND dis.match_status_flag IS NOT NULL
884: AND decode(chk.future_pay_due_date, NULL, aip.accounting_date, decode(sign(aip.accounting_date-chk.future_pay_due_date),1, aip.accounting_date, chk.future_pay_due_date)) BETWEEN l_start_date AND l_end_date
885: AND dis.parent_reversal_id IS NULL
886: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
887: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
888: AND zldf.trx_id = inv.invoice_id )
889: GROUP BY zl.trx_line_dist_id,
890: tax.tax_rate_id,

Line 991: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

987: AND nrec.entity_code = 'AP_INVOICES'
988: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
989: AND nrec.trx_id = inv.invoice_id
990: AND nrec.recoverable_flag = 'N'
991: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
992: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
993: AND zldf.trx_id = inv.invoice_id )
994: GROUP BY zl.trx_line_dist_id,
995: tax.tax_rate_id,

Line 1072: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

1068: AND nrec.entity_code = 'AP_INVOICES'
1069: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
1070: AND nrec.trx_id = inv.invoice_id
1071: AND nrec.recoverable_flag = 'N'
1072: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
1073: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
1074: AND zldf.trx_id = inv.invoice_id )
1075: GROUP BY zl.trx_line_dist_id,
1076: tax.tax_rate_id,

Line 1176: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

1172: AND zlp.entity_code = 'AP_INVOICES'
1173: AND zlp.trx_line_dist_id = pre.invoice_distribution_id )
1174: AND pre.accounting_date BETWEEN l_start_date AND l_end_date
1175: AND dis.parent_reversal_id IS NULL
1176: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
1177: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
1178: AND zldf.trx_id = inv.invoice_id )
1179: GROUP BY zl.trx_line_dist_id,
1180: tax.tax_rate_id,