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 699: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf

695: from ap_invoice_distributions dis2
696: where dis2.invoice_id = inv.invoice_id
697: and dis2.accounting_date not between l_start_date and l_end_date)))
698: --bug10422464 - end
699: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf
700: WHERE SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'DEB/M'
701: AND zldf.trx_id = inv.invoice_id )
702: GROUP BY zl.trx_line_dist_id,
703: tax.tax_rate_id,

Line 805: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf

801: AND dis.line_type_lookup_code = 'PREPAY'
802: AND zl.trx_line_dist_id = dis.invoice_distribution_id
803: AND dis.match_status_flag IS NOT NULL
804: AND (dis.accounting_date BETWEEN l_start_date AND l_end_date)
805: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf
806: WHERE SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'DEB/M'
807: AND zldf.trx_id = inv.invoice_id )
808: GROUP BY zl.trx_line_dist_id,
809: tax.tax_rate_id,

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

929: from ap_invoice_distributions dis2
930: where dis2.invoice_id = inv.invoice_id
931: and dis2.accounting_date not between l_start_date and l_end_date)))
932: --bug10422464 - end
933: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
934: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
935: AND zldf.trx_id = inv.invoice_id )
936: GROUP BY zl.trx_line_dist_id,
937: tax.tax_rate_id,

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

1049: AND nrec.entity_code = 'AP_INVOICES'
1050: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
1051: AND nrec.trx_id = inv.invoice_id
1052: AND nrec.recoverable_flag = 'N'
1053: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
1054: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
1055: AND zldf.trx_id = inv.invoice_id )
1056: GROUP BY zl.trx_line_dist_id,
1057: tax.tax_rate_id,

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

1147: AND nrec.entity_code = 'AP_INVOICES'
1148: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
1149: AND nrec.trx_id = inv.invoice_id
1150: AND nrec.recoverable_flag = 'N'
1151: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
1152: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
1153: AND zldf.trx_id = inv.invoice_id )
1154: GROUP BY zl.trx_line_dist_id,
1155: tax.tax_rate_id,

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

1274: from ap_invoice_distributions dis2
1275: where dis2.invoice_id = inv.invoice_id
1276: and dis2.accounting_date not between l_start_date and l_end_date)))
1277: --bug10422464 - end
1278: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
1279: SUBSTR(zldf.document_sub_type, LENGTH(zldf.document_sub_type) -4, 5) = 'CRE/M'
1280: AND zldf.trx_id = inv.invoice_id )
1281: GROUP BY zl.trx_line_dist_id,
1282: tax.tax_rate_id,