[Home] [Help]
370: (SELECT /*+ no_unnest index(zf,ZX_LINES_DET_FACTORS_U1) */ 'Line Determining Factors Exist'
371: FROM zx_lines_det_factors zf
372: WHERE zf.application_id = 200
373: AND zf.entity_code = 'AP_INVOICES'
374: AND zf.event_class_code IN ('STANDARD INVOICES',
375: 'PREPAYMENT INVOICES',
376: 'EXPENSE REPORTS')
377: -- bug 7233679
378: AND ZF.TRX_LEVEL_TYPE = 'LINE'
484: -- 1. Invoices that have gone through tax calculation on recouped
485: -- prepay distributions during matching AND tax is calculated
486: -- for the first time on the invoice.
487: -- 2. This is required to pass document level event type is passed
488: -- to eTax as STANDARD UPDATED and line level action as CREATE.
489: -- 3. This update must happen ONLY after populate_headers_gt is
490: -- invoked.
491: --
492:
504: (SELECT 'Line Determining Factors Exist'
505: from zx_lines_det_factors zf
506: where zf.application_id = 200
507: and zf.entity_code = 'AP_INVOICES'
508: and zf.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
509: and zf.trx_id = ail.invoice_id
510: and zf.trx_line_id = ail.line_number);
511:
512: l_count := SQL%ROWCOUNT;
1262: -- would have purged zx_trx_headers_gt and zx_transaction_lines_gt.
1263: -- 3. In this case, the staging table will need to repopulated.
1264: -- Parameter P_eTax_Already_called_flag must be passed as 'Y'
1265: -- to ensure document level event type is passed to eTax
1266: -- as 'STANDARD UPDATED'.
1267: -- 4. Use Case is importing ERS invoices matched to complex work
1268: -- purchase orders with paid advances/prepayments.
1269:
1270: -----------------------------------------------------------------
1826: AND EXISTS (SELECT /*+ NO_UNNEST */ 1
1827: FROM zx_rec_nrec_dist zd
1828: WHERE zd.application_id = 200
1829: AND zd.entity_code = 'AP_INVOICES'
1830: AND zd.event_class_code IN ( 'STANDARD INVOICES', 'EXPENSE REPORTS', 'PREPAYMENT INVOICES' )
1831: AND zd.trx_id = aid2.invoice_id
1832: AND zd.rec_nrec_tax_dist_id = aid2.detail_tax_dist_id
1833: AND Nvl(zd.inclusive_flag, 'N') = 'Y'))
1834: WHERE aid1.invoice_id IN (SELECT /*+ cardinality(gt 10) unnest */ DISTINCT(trx_id)
1834: WHERE aid1.invoice_id IN (SELECT /*+ cardinality(gt 10) unnest */ DISTINCT(trx_id)
1835: FROM zx_trx_headers_gt gt
1836: WHERE application_id = 200
1837: AND entity_code = 'AP_INVOICES'
1838: AND event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES'))
1839: AND aid1.line_type_lookup_code IN ('ITEM', 'ACCRUAL', 'FREIGHT', 'MISCELLANEOUS') --bug9314506
1840: AND NOT EXISTS (SELECT /*+ nl_aj */ 1
1841: FROM ap_invoice_lines_all ail
1842: WHERE ail.invoice_id = aid1.invoice_id
1911: AND EXISTS (SELECT /*+ NO_UNNEST */ 1
1912: FROM zx_rec_nrec_dist zd
1913: WHERE zd.application_id = 200
1914: AND zd.entity_code = 'AP_INVOICES'
1915: AND zd.event_class_code IN ( 'STANDARD INVOICES', 'EXPENSE REPORTS', 'PREPAYMENT INVOICES' )
1916: AND zd.trx_id = aid2.invoice_id
1917: AND zd.rec_nrec_tax_dist_id = aid2.detail_tax_dist_id
1918: AND Nvl(zd.inclusive_flag, 'N') = 'Y'))
1919: WHERE aid1.invoice_id = p_invoice_id
2019: AND REC.Effective_From <= AID.Accounting_Date
2020: AND NVL(REC.Effective_To, AID.Accounting_Date) >= AID.Accounting_Date
2021: AND REC.Active_Flag = 'Y'
2022: AND REC.Percentage_Rate = AID.Rec_NRec_Rate
2023: AND REC.Tax_Rate_Code = 'STANDARD-' || REC.Percentage_Rate
2024: AND AID.Line_Type_Lookup_Code = 'REC_TAX')
2025: WHERE AID.invoice_id = l_inv_header_rec.invoice_id
2026: AND AID.historical_flag = 'Y'
2027: AND AID.line_type_lookup_code = 'REC_TAX'
3575: FROM zx_lines_summary zls
3576: WHERE zls.application_id = 200
3577: AND zls.entity_code = 'AP_INVOICES'
3578: AND zls.event_class_code IN
3579: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
3580: AND zls.trx_id = ai.invoice_id
3581: AND NVL(zls.reporting_only_flag, 'N') = 'N')
3582: WHERE ai.invoice_id = l_inv_header_rec.invoice_id;
3583:
7181: INTO l_tax_already_calculated_line
7182: FROM zx_lines_det_factors
7183: WHERE application_id = 200
7184: AND entity_code = 'AP_INVOICES'
7185: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
7186: AND trx_id = l_inv_line_list(i).invoice_id
7187: AND trx_line_id = l_inv_line_list(i).line_number
7188: AND ROWNUM = 1;
7189:
7445: -- ALL
7446: l_line_amt_includes_tax_flag := 'A';
7447:
7448: ELSE
7449: -- STANDARD
7450: l_line_amt_includes_tax_flag := 'S';
7451:
7452: END IF;
7453: END IF;
7460: INTO l_init_line_amt_incl_tax_fg
7461: FROM zx_lines_det_factors
7462: WHERE application_id = 200
7463: AND entity_code = 'AP_INVOICES'
7464: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
7465: AND trx_id = l_inv_line_list(i).invoice_id
7466: AND trx_line_id = l_inv_line_list(i).line_number
7467: AND rownum = 1;
7468:
7930: trans_lines(i).account_ccid := l_inv_line_list(i).default_dist_ccid;
7931:
7932: trans_lines(i).trx_line_quantity := nvl(l_inv_line_list(i).quantity_invoiced, 1);
7933:
7934: --Bug10621602 In Retainange Release Case we will pass unit price from standard invoice to compute the
7935: --proper variances
7936: IF P_Invoice_Header_Rec.invoice_type_lookup_code ='RETAINAGE RELEASE' AND
7937: l_inv_line_list(i).line_type_lookup_code = 'RETAINAGE RELEASE' AND
7938: l_inv_line_list(i).po_line_location_id IS NOT NULL THEN
8456: -- ALL
8457: l_line_amt_includes_tax_flag := 'A';
8458:
8459: ELSE
8460: -- STANDARD
8461: l_line_amt_includes_tax_flag := 'S';
8462: END IF;
8463: END IF;
8464:
8471: ELSIF p_inv_line_list(i).amount_includes_tax_flag = 'N' THEN
8472: -- NONE
8473: l_line_amt_includes_tax_flag := 'N';
8474: ELSIF p_inv_line_list(i).amount_includes_tax_flag = 'S' THEN
8475: -- STANDARD
8476: l_line_amt_includes_tax_flag := 'S';
8477: ELSE
8478: -- STANDARD
8479: l_line_amt_includes_tax_flag := 'S';
8474: ELSIF p_inv_line_list(i).amount_includes_tax_flag = 'S' THEN
8475: -- STANDARD
8476: l_line_amt_includes_tax_flag := 'S';
8477: ELSE
8478: -- STANDARD
8479: l_line_amt_includes_tax_flag := 'S';
8480: END IF;
8481: END IF;
8482:
9318: and nvl(p_inv_line_list(i).line_type_lookup_code, 'N') <> 'PREPAY') THEN
9319: -- ALL
9320: l_line_amt_includes_tax_flag := 'A';
9321: ELSE
9322: -- STANDARD
9323: l_line_amt_includes_tax_flag := 'S';
9324: END IF;
9325: END IF;
9326: trans_lines(l_pseudo).line_amt_includes_tax_flag:= l_line_amt_includes_tax_flag;
9540: -- ALL
9541: l_line_amt_includes_tax_flag := 'A';
9542:
9543: ELSE
9544: -- STANDARD
9545: IF p_calling_mode = 'VALIDATE IMPORT' THEN /* if condition added for 6010950 -
9546: For tax only invoices we need to pass it as 'N' */
9547: l_line_amt_includes_tax_flag := 'N';
9548: ELSE
9889: FROM zx_import_tax_lines_gt
9890: WHERE trx_id = P_Invoice_Header_Rec.invoice_id
9891: AND application_id = 200
9892: AND entity_code ='AP_INVOICES'
9893: AND event_class_code IN ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')) LOOP
9894:
9895: l_debug_info := '1 '|| i.ATTRIBUTE1;
9896: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
9897: l_debug_info := '2 '||i.ATTRIBUTE2;
10350: and nvl(l_inv_tax_list(i).line_type_lookup_code, 'N') <> 'PREPAY') THEN
10351: -- ALL
10352: l_line_amt_includes_tax_flag := 'A';
10353: ELSE
10354: -- STANDARD
10355: l_line_amt_includes_tax_flag := 'S';
10356: END IF;
10357: END IF;
10358: trans_lines(l_pseudo).line_amt_includes_tax_flag:= l_line_amt_includes_tax_flag;
10612: -- ALL
10613: l_line_amt_includes_tax_flag := 'A';
10614:
10615: ELSE
10616: -- STANDARD
10617: l_line_amt_includes_tax_flag := 'S';
10618:
10619: END IF;
10620: END IF;
10900: FROM zx_import_tax_lines_gt
10901: WHERE trx_id = P_Invoice_Header_Rec.invoice_id
10902: AND application_id = 200
10903: AND entity_code ='AP_INVOICES'
10904: AND event_class_code IN ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')) LOOP
10905:
10906: l_debug_info := '1 '|| i.ATTRIBUTE1;
10907: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
10908: l_debug_info := '2 '||i.ATTRIBUTE2;
11379: AND PLL.po_header_id = l_ref_doc_trx_id;
11380:
11381: IF ( l_inv_dist_list(i).RELATED_RETAINAGE_DIST_ID IS NOT NULL) THEN
11382:
11383: -- For standard invoice having retainage we will populate the char4 column as 'S' and will get the retained amount
11384:
11385: trans_dists(j).char4 := 'S';
11386:
11387: select amount into l_retained_amount from ap_invoice_distributions_all aid
12042:
12043: l_line_amt_includes_tax_flag := 'I';
12044:
12045: ELSE
12046: -- STANDARD
12047: l_line_amt_includes_tax_flag := 'S';
12048:
12049: END IF;
12050: END IF;
12679: /* -- Bug8575619 start */
12680: and tax_dist.invoice_id = zx_dist.trx_id
12681: and zx_dist.application_id = 200
12682: and zx_dist.entity_code = 'AP_INVOICES'
12683: and zx_dist.event_class_code IN ('STANDARD INVOICES',
12684: 'PREPAYMENT INVOICES',
12685: 'EXPENSE REPORTS')
12686: /* -- Bug8575619 end */
12687: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')
12898: /* -- Bug8575619 start */
12899: and tax_dist.invoice_id = zx_dist.trx_id
12900: and zx_dist.application_id = 200
12901: and zx_dist.entity_code = 'AP_INVOICES'
12902: and zx_dist.event_class_code IN ('STANDARD INVOICES',
12903: 'PREPAYMENT INVOICES',
12904: 'EXPENSE REPORTS')
12905: /* -- Bug8575619 end */
12906: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TERV', 'TRV')
13120: /* -- Bug8575619 start */
13121: and tax_dist.invoice_id = zx_dist.trx_id
13122: and zx_dist.application_id = 200
13123: and zx_dist.entity_code = 'AP_INVOICES'
13124: and zx_dist.event_class_code IN ('STANDARD INVOICES',
13125: 'PREPAYMENT INVOICES',
13126: 'EXPENSE REPORTS')
13127: /* -- Bug8575619 end */
13128: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')
13349: /* -- Bug8575619 start */
13350: and tax_dist.invoice_id = zx_dist.trx_id
13351: and zx_dist.application_id = 200
13352: and zx_dist.entity_code = 'AP_INVOICES'
13353: and zx_dist.event_class_code IN ('STANDARD INVOICES',
13354: 'PREPAYMENT INVOICES',
13355: 'EXPENSE REPORTS')
13356: /* -- Bug8575619 end */
13357: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')
14054: b.cancel_flag
14055: from zx_lines_summary b
14056: where b.application_id = 200
14057: and b.entity_code = 'AP_INVOICES'
14058: and b.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14059: and b.summary_tax_line_id = a.summary_tax_line_id
14060: and b.trx_id = p_invoice_id)
14061: WHERE a.invoice_id = p_invoice_id
14062: AND a.line_type_lookup_code = 'TAX'
14064: (select 'Detail Line'
14065: from zx_lines zx
14066: where zx.application_id = 200
14067: and zx.entity_code = 'AP_INVOICES'
14068: and zx.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14069: and zx.summary_tax_line_id = a.summary_tax_line_id
14070: and zx.trx_id = p_invoice_id);
14071:
14072: -------------------------------------------------------------------
14082: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
14083: FROM zx_lines zl
14084: WHERE zl.application_id = 200
14085: AND zl.entity_code = 'AP_INVOICES'
14086: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14087: AND zl.trx_id = ail.invoice_id
14088: AND zl.trx_line_id = ail.line_number
14089: AND NVL(zl.self_assessed_flag, 'N') = 'N'
14090: AND NVL(zl.reporting_only_flag, 'N') = 'N'
14130: (select nvl(b.tax_amt,0),nvl(b.tax_amt_funcl_curr,0)
14131: from zx_lines_summary b
14132: where b.application_id = 200
14133: and b.entity_code = 'AP_INVOICES'
14134: and b.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14135: and b.trx_id = a.invoice_id
14136: and b.summary_tax_line_id = a.summary_tax_line_id)
14137: WHERE a.invoice_id = p_invoice_id
14138: AND a.line_type_lookup_code = 'TAX'
14140: (select 'Detail Line'
14141: from zx_lines zx
14142: where zx.application_id = 200
14143: and zx.entity_code = 'AP_INVOICES'
14144: and zx.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14145: and zx.summary_tax_line_id = a.summary_tax_line_id
14146: and zx.trx_id = p_invoice_id
14147: and zx.trx_line_id = p_line_number);
14148:
16271: AND EXISTS (SELECT 1
16272: FROM zx_rec_nrec_dist zd
16273: WHERE zd.application_id =200
16274: AND zd.entity_code = 'AP_INVOICES'
16275: AND zd.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
16276: AND zd.trx_id = aid2.invoice_id
16277: AND zd.rec_nrec_tax_dist_id = aid2.detail_tax_dist_id
16278: AND NVL(zd.inclusive_flag,'N') = 'Y')),0),
16279: aid1.base_amount =aid1.base_amount + nvl((SELECT SUM(nvl(base_amount,0))
16286: AND EXISTS (SELECT 1
16287: FROM zx_rec_nrec_dist zd1
16288: WHERE zd1.application_id =200
16289: AND zd1.entity_code = 'AP_INVOICES'
16290: AND zd1.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
16291: AND zd1.trx_id = aid3.invoice_id
16292: AND zd1.rec_nrec_tax_dist_id = aid3.detail_tax_dist_id
16293: AND NVL(zd1.inclusive_flag,'N') = 'Y')),0) --ER CHANGES
16294: WHERE aid1.invoice_id = p_invoice_id
17215: 200, --application_id
17216: 'AP_INVOICES', --entity_code
17217: (CASE
17218: WHEN ai.invoice_type_lookup_code IN
17219: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
17220: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
17221: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE', 'PAYMENT REQUEST') -- bug 9281264
17222: THEN 'STANDARD INVOICES'
17223: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')
17218: WHEN ai.invoice_type_lookup_code IN
17219: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
17220: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
17221: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE', 'PAYMENT REQUEST') -- bug 9281264
17222: THEN 'STANDARD INVOICES'
17223: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')
17224: or (p_calling_mode IN ('RECOUPMENT', 'DISTRIBUTE RECOUP'))
17225: THEN 'PREPAYMENT INVOICES'
17226: WHEN ai.invoice_type_lookup_code = 'EXPENSE REPORT'
17227: THEN 'EXPENSE REPORTS'
17228: END), --event_class_code
17229: (CASE
17230: WHEN ai.invoice_type_lookup_code IN
17231: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
17232: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
17233: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE', 'PAYMENT REQUEST') -- bug 9281264
17234: THEN 'STANDARD '
17235: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')
17230: WHEN ai.invoice_type_lookup_code IN
17231: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
17232: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
17233: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE', 'PAYMENT REQUEST') -- bug 9281264
17234: THEN 'STANDARD '
17235: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')
17236: or (p_calling_mode IN ('RECOUPMENT', 'DISTRIBUTE RECOUP'))
17237: THEN 'PREPAYMENT '
17238: WHEN ai.invoice_type_lookup_code = 'EXPENSE REPORT'
17253: FROM zx_lines_det_factors
17254: WHERE application_id = 200
17255: AND entity_code = 'AP_INVOICES'
17256: AND trx_id = ai.invoice_id
17257: AND event_class_code in ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')
17258: AND ROWNUM=1))
17259: --- End for bug 6485124
17260: WHEN 'Y' THEN 'UPDATED'
17261: ELSE 'CREATED'
17299: ELSE NULL
17300: END), --related_doc_entity_code
17301: (CASE
17302: WHEN related_ai.invoice_type_lookup_code IN
17303: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
17304: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
17305: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
17306: THEN 'STANDARD INVOICES'
17307: WHEN ai.invoice_type_lookup_code = 'PREPAYMENT'
17302: WHEN related_ai.invoice_type_lookup_code IN
17303: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
17304: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
17305: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
17306: THEN 'STANDARD INVOICES'
17307: WHEN ai.invoice_type_lookup_code = 'PREPAYMENT'
17308: THEN 'PREPAYMENT INVOICES'
17309: WHEN ai.invoice_type_lookup_code = 'EXPENSE REPORT'
17310: THEN 'EXPENSE REPORTS'
17769: AND EXISTS (SELECT 1
17770: FROM zx_rec_nrec_dist zd1
17771: WHERE zd1.application_id =200
17772: AND zd1.entity_code = 'AP_INVOICES'
17773: AND zd1.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
17774: AND zd1.trx_id = aid2.invoice_id
17775: AND zd1.rec_nrec_tax_dist_id = aid2.detail_tax_dist_id
17776: AND NVL(zd1.inclusive_flag,'N') = 'Y')),0),
17777: aid1.base_amount =aid1.base_amount- nvl((SELECT SUM(nvl(base_amount,0))
17783: AND EXISTS (SELECT 1
17784: FROM zx_rec_nrec_dist zd2
17785: WHERE zd2.application_id =200
17786: AND zd2.entity_code = 'AP_INVOICES'
17787: AND zd2.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
17788: AND zd2.trx_id = aid3.invoice_id
17789: AND zd2.rec_nrec_tax_dist_id = aid3.detail_tax_dist_id
17790: AND NVL(zd2.inclusive_flag,'N') = 'Y')),0)
17791: WHERE aid1.invoice_id = p_invoice_header_rec.invoice_id
18561: AND ai.vendor_id = ap.vendor_id
18562: AND ai.vendor_site_id = aps.vendor_site_id
18563: AND zls.application_id = 200
18564: AND zls.entity_code = 'AP_INVOICES'
18565: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
18566: AND zls.trx_id = ai.invoice_id
18567: AND NVL(zls.tax_amt_included_flag, 'N') = 'N'
18568: AND NVL(zls.self_assessed_flag, 'N') = 'N'
18569: AND NVL(zls.reporting_only_flag, 'N') = 'N'
18660: FROM zx_lines_summary zls
18661: WHERE zls.application_id = 200
18662: AND zls.entity_code = 'AP_INVOICES'
18663: AND zls.event_class_code IN
18664: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
18665: AND zls.trx_id = ai.invoice_id
18666: AND NVL(zls.reporting_only_flag, 'N') = 'N')
18667: WHERE ai.invoice_id = P_Invoice_Header_Rec.invoice_id
18668: RETURNING ai.total_tax_amount, ai.self_assessed_tax_amount
18772: CURSOR c_trx
18773: IS
18774: SELECT
18775: (CASE
18776: WHEN ai.invoice_type_lookup_code IN('STANDARD' , 'CREDIT' , 'DEBIT' ,
18777: 'MIXED' , 'ADJUSTMENT' , 'PO PRICE ADJUST' , 'INVOICE REQUEST' ,
18778: 'CREDIT MEMO REQUEST' , 'RETAINAGE RELEASE','PAYMENT REQUEST')--Bug9122724
18779: THEN 'STANDARD INVOICES'
18780: WHEN(ai.invoice_type_lookup_code='PREPAYMENT')
18775: (CASE
18776: WHEN ai.invoice_type_lookup_code IN('STANDARD' , 'CREDIT' , 'DEBIT' ,
18777: 'MIXED' , 'ADJUSTMENT' , 'PO PRICE ADJUST' , 'INVOICE REQUEST' ,
18778: 'CREDIT MEMO REQUEST' , 'RETAINAGE RELEASE','PAYMENT REQUEST')--Bug9122724
18779: THEN 'STANDARD INVOICES'
18780: WHEN(ai.invoice_type_lookup_code='PREPAYMENT')
18781: THEN 'PREPAYMENT INVOICES'
18782: WHEN ai.invoice_type_lookup_code='EXPENSE REPORT'
18783: THEN 'EXPENSE REPORTS'
18783: THEN 'EXPENSE REPORTS'
18784: END) event_class_code
18785: ,
18786: (CASE
18787: WHEN ai.invoice_type_lookup_code IN('STANDARD' , 'CREDIT' , 'DEBIT' ,
18788: 'MIXED' , 'ADJUSTMENT' , 'PO PRICE ADJUST' , 'INVOICE REQUEST' ,
18789: 'CREDIT MEMO REQUEST' , 'RETAINAGE RELEASE','PAYMENT REQUEST')--Bug9122724
18790: THEN 'STANDARD '
18791: WHEN(ai.invoice_type_lookup_code='PREPAYMENT')
18786: (CASE
18787: WHEN ai.invoice_type_lookup_code IN('STANDARD' , 'CREDIT' , 'DEBIT' ,
18788: 'MIXED' , 'ADJUSTMENT' , 'PO PRICE ADJUST' , 'INVOICE REQUEST' ,
18789: 'CREDIT MEMO REQUEST' , 'RETAINAGE RELEASE','PAYMENT REQUEST')--Bug9122724
18790: THEN 'STANDARD '
18791: WHEN(ai.invoice_type_lookup_code='PREPAYMENT')
18792: THEN 'PREPAYMENT '
18793: WHEN ai.invoice_type_lookup_code='EXPENSE REPORT'
18794: THEN 'EXPENSE REPORT '