DBA Data[Home] [Help]

APPS.JAI_FBT_PROCESS_P dependencies on JAI_AP_MATCH_INV_TAXES

Line 1146: FROM jai_ap_match_inv_taxes jamit

1142: )
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

Line 1179: FROM JAI_AP_MATCH_INV_TAXES JAMIT

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
1180: WHERE JAMIT.INVOICE_DISTRIBUTION_ID
1181: = AIDA.INVOICE_DISTRIBUTION_ID
1182: AND RECOVERABLE_FLAG = 'Y'
1183: /* ja_in_ap_tax_distributions jiatdi

Line 1261: FROM jai_ap_match_inv_taxes jamit

1257: )
1258: --modified by lvxiao for upgrade code for new changes to R12 from 11i on 06-Nov-2008, begin
1259: -------------------------------------------------------------------------------------------
1260: AND NOT EXISTS ( SELECT 1
1261: FROM jai_ap_match_inv_taxes jamit
1262: WHERE jamit.invoice_distribution_id
1263: = det.invoice_distribution_id
1264: /* ja_in_ap_tax_distributions jiatd
1265: WHERE jiatd.invoice_id