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.AP_ETAX_SERVICES_PKG dependencies on STANDARD

Line 280: AND zf.event_class_code IN ('STANDARD INVOICES',

276: (SELECT 'Line Determining Factors Exist'
277: FROM zx_lines_det_factors zf
278: WHERE zf.application_id = 200
279: AND zf.entity_code = 'AP_INVOICES'
280: AND zf.event_class_code IN ('STANDARD INVOICES',
281: 'PREPAYMENT INVOICES',
282: 'EXPENSE REPORTS')
283: -- bug 7233679
284: AND ZF.TRX_LEVEL_TYPE = 'LINE'

Line 365: -- to eTax as STANDARD UPDATED and line level action as CREATE.

361: -- 1. Invoices that have gone through tax calculation on recouped
362: -- prepay distributions during matching AND tax is calculated
363: -- for the first time on the invoice.
364: -- 2. This is required to pass document level event type is passed
365: -- to eTax as STANDARD UPDATED and line level action as CREATE.
366: -- 3. This update must happen ONLY after populate_headers_gt is
367: -- invoked.
368: --
369:

Line 381: and zf.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

377: (SELECT 'Line Determining Factors Exist'
378: from zx_lines_det_factors zf
379: where zf.application_id = 200
380: and zf.entity_code = 'AP_INVOICES'
381: and zf.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
382: and zf.trx_id = ail.invoice_id
383: and zf.trx_line_id = ail.line_number);
384:
385: l_count := SQL%ROWCOUNT;

Line 934: -- as 'STANDARD UPDATED'.

930: -- would have purged zx_trx_headers_gt and zx_transaction_lines_gt.
931: -- 3. In this case, the staging table will need to repopulated.
932: -- Parameter P_eTax_Already_called_flag must be passed as 'Y'
933: -- to ensure document level event type is passed to eTax
934: -- as 'STANDARD UPDATED'.
935: -- 4. Use Case is importing ERS invoices matched to complex work
936: -- purchase orders with paid advances/prepayments.
937:
938: -----------------------------------------------------------------

Line 1542: AND REC.Tax_Rate_Code = 'STANDARD-' || REC.Percentage_Rate

1538: AND REC.Effective_From <= AID.Accounting_Date
1539: AND NVL(REC.Effective_To, AID.Accounting_Date) >= AID.Accounting_Date
1540: AND REC.Active_Flag = 'Y'
1541: AND REC.Percentage_Rate = AID.Rec_NRec_Rate
1542: AND REC.Tax_Rate_Code = 'STANDARD-' || REC.Percentage_Rate
1543: AND AID.Line_Type_Lookup_Code = 'REC_TAX')
1544: WHERE AID.invoice_id = l_inv_header_rec.invoice_id
1545: AND AID.historical_flag = 'Y'
1546: AND AID.line_type_lookup_code = 'REC_TAX'

Line 6066: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

6062: INTO l_tax_already_calculated_line
6063: FROM zx_lines_det_factors
6064: WHERE application_id = 200
6065: AND entity_code = 'AP_INVOICES'
6066: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6067: AND trx_id = l_inv_line_list(i).invoice_id
6068: AND trx_line_id = l_inv_line_list(i).line_number
6069: AND ROWNUM = 1;
6070:

Line 6254: -- STANDARD

6250: -- ALL
6251: l_line_amt_includes_tax_flag := 'A';
6252:
6253: ELSE
6254: -- STANDARD
6255: l_line_amt_includes_tax_flag := 'S';
6256:
6257: END IF;
6258: END IF;

Line 6268: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

6264: INTO l_init_line_amt_incl_tax_fg
6265: FROM zx_lines_det_factors
6266: WHERE application_id = 200
6267: AND entity_code = 'AP_INVOICES'
6268: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6269: AND trx_id = l_inv_line_list(i).invoice_id
6270: AND trx_line_id = l_inv_line_list(i).line_number
6271: AND rownum = 1;
6272:

Line 6984: -- STANDARD

6980: -- ALL
6981: l_line_amt_includes_tax_flag := 'A';
6982:
6983: ELSE
6984: -- STANDARD
6985: l_line_amt_includes_tax_flag := 'S';
6986: END IF;
6987: END IF;
6988:

Line 6999: -- STANDARD

6995: ELSIF p_inv_line_list(i).amount_includes_tax_flag = 'N' THEN
6996: -- NONE
6997: l_line_amt_includes_tax_flag := 'N';
6998: ELSIF p_inv_line_list(i).amount_includes_tax_flag = 'S' THEN
6999: -- STANDARD
7000: l_line_amt_includes_tax_flag := 'S';
7001: ELSE
7002: -- STANDARD
7003: l_line_amt_includes_tax_flag := 'S';

Line 7002: -- STANDARD

6998: ELSIF p_inv_line_list(i).amount_includes_tax_flag = 'S' THEN
6999: -- STANDARD
7000: l_line_amt_includes_tax_flag := 'S';
7001: ELSE
7002: -- STANDARD
7003: l_line_amt_includes_tax_flag := 'S';
7004: END IF;
7005: END IF;
7006:

Line 7579: -- STANDARD

7575: -- ALL
7576: l_line_amt_includes_tax_flag := 'A';
7577:
7578: ELSE
7579: -- STANDARD
7580: IF p_calling_mode = 'VALIDATE IMPORT' THEN /* if condition added for 6010950 -
7581: For tax only invoices we need to pass it as 'N' */
7582: l_line_amt_includes_tax_flag := 'N';
7583: ELSE

Line 8326: -- STANDARD

8322: -- ALL
8323: l_line_amt_includes_tax_flag := 'A';
8324:
8325: ELSE
8326: -- STANDARD
8327: l_line_amt_includes_tax_flag := 'S';
8328:
8329: END IF;
8330: END IF;

Line 9448: -- STANDARD

9444:
9445: l_line_amt_includes_tax_flag := 'I';
9446:
9447: ELSE
9448: -- STANDARD
9449: l_line_amt_includes_tax_flag := 'S';
9450:
9451: END IF;
9452: END IF;

Line 13573: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',

13569: 200, --application_id
13570: 'AP_INVOICES', --entity_code
13571: (CASE
13572: WHEN ai.invoice_type_lookup_code IN
13573: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
13574: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
13575: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
13576: THEN 'STANDARD INVOICES'
13577: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')

Line 13576: THEN 'STANDARD INVOICES'

13572: WHEN ai.invoice_type_lookup_code IN
13573: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
13574: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
13575: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
13576: THEN 'STANDARD INVOICES'
13577: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')
13578: or (p_calling_mode IN ('RECOUPMENT', 'DISTRIBUTE RECOUP'))
13579: THEN 'PREPAYMENT INVOICES'
13580: WHEN ai.invoice_type_lookup_code = 'EXPENSE REPORT'

Line 13585: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',

13581: THEN 'EXPENSE REPORTS'
13582: END), --event_class_code
13583: (CASE
13584: WHEN ai.invoice_type_lookup_code IN
13585: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
13586: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
13587: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
13588: THEN 'STANDARD '
13589: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')

Line 13588: THEN 'STANDARD '

13584: WHEN ai.invoice_type_lookup_code IN
13585: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
13586: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
13587: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
13588: THEN 'STANDARD '
13589: WHEN (ai.invoice_type_lookup_code = 'PREPAYMENT')
13590: or (p_calling_mode IN ('RECOUPMENT', 'DISTRIBUTE RECOUP'))
13591: THEN 'PREPAYMENT '
13592: WHEN ai.invoice_type_lookup_code = 'EXPENSE REPORT'

Line 13611: AND event_class_code in ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')

13607: FROM zx_lines_det_factors
13608: WHERE application_id = 200
13609: AND entity_code = 'AP_INVOICES'
13610: AND trx_id = ai.invoice_id
13611: AND event_class_code in ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')
13612: AND ROWNUM=1))
13613: --- End for bug 6485124
13614: WHEN 'Y' THEN 'UPDATED'
13615: ELSE 'CREATED'

Line 13657: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',

13653: ELSE NULL
13654: END), --related_doc_entity_code
13655: (CASE
13656: WHEN related_ai.invoice_type_lookup_code IN
13657: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
13658: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
13659: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
13660: THEN 'STANDARD INVOICES'
13661: WHEN ai.invoice_type_lookup_code = 'PREPAYMENT'

Line 13660: THEN 'STANDARD INVOICES'

13656: WHEN related_ai.invoice_type_lookup_code IN
13657: ('STANDARD', 'CREDIT', 'DEBIT', 'MIXED',
13658: 'ADJUSTMENT', 'PO PRICE ADJUST', 'INVOICE REQUEST',
13659: 'CREDIT MEMO REQUEST', 'RETAINAGE RELEASE')
13660: THEN 'STANDARD INVOICES'
13661: WHEN ai.invoice_type_lookup_code = 'PREPAYMENT'
13662: THEN 'PREPAYMENT INVOICES'
13663: WHEN ai.invoice_type_lookup_code = 'EXPENSE REPORT'
13664: THEN 'EXPENSE REPORTS'

Line 14734: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

14730: AND ai.vendor_id = ap.vendor_id
14731: AND ai.vendor_site_id = aps.vendor_site_id
14732: AND zls.application_id = 200
14733: AND zls.entity_code = 'AP_INVOICES'
14734: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14735: AND zls.trx_id = ai.invoice_id
14736: AND NVL(zls.tax_amt_included_flag, 'N') = 'N'
14737: AND NVL(zls.self_assessed_flag, 'N') = 'N'
14738: AND NVL(zls.reporting_only_flag, 'N') = 'N'

Line 14821: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

14817: 0))
14818: FROM zx_lines_summary zls
14819: WHERE zls.application_id = 200
14820: AND zls.entity_code = 'AP_INVOICES'
14821: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14822: AND zls.trx_id = ai.invoice_id
14823: AND NVL(zls.reporting_only_flag, 'N') = 'N')
14824: WHERE ai.invoice_id = P_Invoice_Header_Rec.invoice_id
14825: RETURNING ai.total_tax_amount, ai.self_assessed_tax_amount