APPS.JAI_AP_DTC_DEFAULTATION_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 2290: --Rewrite cursor g_get_inv_dist, add left outer join to po_distributions_all table.

2286: ORDER BY INVOICE_DISTRIBUTION_ID;
2287: Commented by Chong for bug#16367707 End*/
2288: --Added by Chong for bug#16367707 Start
2289: -------------------------------------------------------------------------
2290: --Rewrite cursor g_get_inv_dist, add left outer join to po_distributions_all table.
2291: --+ 1). Update SQL to add alias for each table.
2292: --+ 2). When PO/Receipt Match invoice, get PO charge account in priority.
2293: cursor c_get_inv_dist
2294: is

Line 2307: ,PO_DISTRIBUTIONS_ALL PDA

2303: AIDA.MATCH_STATUS_FLAG,
2304: AIDA.LINE_TYPE_LOOKUP_CODE,
2305: AIDA.ACCOUNTING_DATE
2306: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
2307: ,PO_DISTRIBUTIONS_ALL PDA
2308: WHERE AIDA.INVOICE_ID = cp_inv_id
2309: AND AIDA.PO_DISTRIBUTION_ID = PDA.PO_DISTRIBUTION_ID(+) --Added by Chong for bug#16367707
2310: AND AIDA.LINE_TYPE_LOOKUP_CODE NOT IN
2311: ('PREPAY', 'TIPV', 'TERV', 'TAX', 'MISCELLANEOUS') -- added by zhiwei.xin for bug 13731393 on 29-Feb-2012 begin

Line 2360: ,PO_DISTRIBUTIONS_ALL PDA

2356: AIDA.MATCH_STATUS_FLAG,
2357: AIDA.LINE_TYPE_LOOKUP_CODE,
2358: AIDA.ACCOUNTING_DATE
2359: FROM AP_INVOICE_DISTRIBUTIONS_ALL AIDA
2360: ,PO_DISTRIBUTIONS_ALL PDA
2361: WHERE AIDA.INVOICE_ID = cp_inv_id
2362: AND AIDA.PO_DISTRIBUTION_ID = PDA.PO_DISTRIBUTION_ID(+) --Added by Chong for bug#16367707
2363: AND AIDA.LINE_TYPE_LOOKUP_CODE IN ('MISCELLANEOUS')
2364: AND NOT EXISTS