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.JAI_FBT_PROCESS_P dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 269: ap_invoice_distributions_all

265: SELECT
266: SUM( decode(match_status_flag, 'A', 1, 0))
267: , COUNT(invoice_distribution_id)
268: FROM
269: ap_invoice_distributions_all
270: WHERE invoice_id = pn_invoice_id;
271:
272: ln_total_count NUMBER;
273: ln_validated_cnt NUMBER;

Line 634: , Ap_Invoice_Distributions_All aida

630: IF pn_source = 'Payables' THEN
631: SELECT aia.exchange_rate
632: INTO ln_exchange_rate
633: FROM AP_INVOICES_ALL aia
634: , Ap_Invoice_Distributions_All aida
635: WHERE aida.invoice_distribution_id = pn_inv_dist_id
636: AND aida.invoice_id = aia.invoice_id;
637: ELSE --pn_source = 'Others'
638: SELECT currency_conversion_rate

Line 749: --set invoice_date as ap_invoice_distributions_all.accounting_date.

745: := pn_inv_dist_amt;
746: x_fbt_repository_type.invoice_currency_code
747: := pv_currency;
748:
749: --set invoice_date as ap_invoice_distributions_all.accounting_date.
750: SELECT aida.accounting_date
751: INTO x_fbt_repository_type.invoice_date
752: FROM ap_invoice_distributions_all aida
753: WHERE aida.invoice_distribution_id = pn_inv_dist_id;

Line 752: FROM ap_invoice_distributions_all aida

748:
749: --set invoice_date as ap_invoice_distributions_all.accounting_date.
750: SELECT aida.accounting_date
751: INTO x_fbt_repository_type.invoice_date
752: FROM ap_invoice_distributions_all aida
753: WHERE aida.invoice_distribution_id = pn_inv_dist_id;
754:
755: SELECT invoice_num
756: INTO x_fbt_repository_type.je_name

Line 758: , ap_invoice_distributions_all aida

754:
755: SELECT invoice_num
756: INTO x_fbt_repository_type.je_name
757: FROM ap_invoices_all aia
758: , ap_invoice_distributions_all aida
759: WHERE invoice_distribution_id = pn_inv_dist_id
760: AND aia.invoice_id = aida.invoice_id;
761:
762: --modified by Lv Xiao for bug#7670949 on 26-Dec-2008, begin

Line 768: FROM ap_invoice_distributions_all aida

764: --get invoice line number according to the distribution id
765: SELECT aida.invoice_line_number
766: --aida.distribution_line_number
767: INTO x_fbt_repository_type.JE_LINE_NUM
768: FROM ap_invoice_distributions_all aida
769: WHERE aida.invoice_distribution_id = pn_inv_dist_id;
770: -----------------------------------------------------------------------------------
771: --modified by Lv Xiao for bug#7670949 on 26-Dec-2008, end
772:

Line 1121: , ap_invoice_distributions_all det

1117: , head.exchange_rate
1118: , head.exchange_date
1119: FROM
1120: ap_invoices_all head
1121: , ap_invoice_distributions_all det
1122: , po_distributions_all po
1123: WHERE head.invoice_id = det.invoice_id
1124: -- Modified by Jia for bug#7675638 on 30-Dec-2008, Begin
1125: --------------------------------------------------------------

Line 1147: , ap_invoice_distributions_all aida1

1143: --modified by lvxiao for upgrade code for new changes to R12 from 11i on 06-Nov-2008, begin
1144: -------------------------------------------------------------------------------------------
1145: OR EXISTS (SELECT 1
1146: FROM jai_ap_match_inv_taxes jamit
1147: , ap_invoice_distributions_all aida1
1148: WHERE jamit.invoice_distribution_id
1149: = det.invoice_distribution_id
1150: AND jamit.parent_invoice_distribution_id
1151: = aida1.invoice_distribution_id

Line 1156: , ap_invoice_distributions_all aida1

1152: AND aida1.dist_match_type IN ('ITEM_TO_PO'
1153: , 'ITEM_TO_RECEIPT'
1154: )
1155: /* ja_in_ap_tax_distributions jiatd
1156: , ap_invoice_distributions_all aida1
1157: WHERE jiatd.invoice_id
1158: = det.invoice_id
1159: AND jiatd.distribution_line_number
1160: = det.distribution_line_number

Line 1175: AP_INVOICE_DISTRIBUTIONS_ALL AIDA

1171: -- Modified by Jia for bug#7675638 on 30-Dec-2008, Begin
1172: AND det.invoice_distribution_id IN ( SELECT
1173: aida.invoice_distribution_id
1174: FROM
1175: AP_INVOICE_DISTRIBUTIONS_ALL AIDA
1176: WHERE aida.invoice_id = head.invoice_id
1177: AND NOT EXISTS
1178: ( SELECT 1
1179: FROM JAI_AP_MATCH_INV_TAXES JAMIT

Line 1236: , ap_invoice_distributions_all det

1232: , head.exchange_rate
1233: , head.exchange_date
1234: FROM
1235: ap_invoices_all head
1236: , ap_invoice_distributions_all det
1237: WHERE head.invoice_id = det.invoice_id
1238: -- Modified by Jia for bug#7675638 on 30-Dec-2008, Begin
1239: --------------------------------------------------------------
1240: --AND head.org_id = pn_operating_unit