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.PA_ADJUSTMENTS dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 5837: ' from ap_self_assessed_tax_dist_all apdist' ||

5833: ' and apdist2.invoice_line_number = :invoice_line_number)' ||
5834: ' and apdist1.line_type_lookup_code in (''NONREC_TAX'', ''TIPV'', ''TERV'', ''TRV'')' ||
5835: ' union all'||
5836: ' select apdist.invoice_distribution_id' || /*Self Assessed Tax Changes*/
5837: ' from ap_self_assessed_tax_dist_all apdist' ||
5838: ' where apdist.invoice_id = :invoice_id' ||
5839: ' and apdist.invoice_line_number = :invoice_line_number' ||
5840: ' union all' ||
5841: ' select apdist1.invoice_distribution_id' ||

Line 5842: ' from ap_self_assessed_tax_dist_all apdist1' ||

5838: ' where apdist.invoice_id = :invoice_id' ||
5839: ' and apdist.invoice_line_number = :invoice_line_number' ||
5840: ' union all' ||
5841: ' select apdist1.invoice_distribution_id' ||
5842: ' from ap_self_assessed_tax_dist_all apdist1' ||
5843: ' where apdist1.charge_Applicable_to_dist_id in' ||
5844: ' ( select apdist2.invoice_distribution_id' ||
5845: ' from ap_self_assessed_tax_dist_all apdist2' ||
5846: ' where apdist2.invoice_id = :invoice_id' ||

Line 5845: ' from ap_self_assessed_tax_dist_all apdist2' ||

5841: ' select apdist1.invoice_distribution_id' ||
5842: ' from ap_self_assessed_tax_dist_all apdist1' ||
5843: ' where apdist1.charge_Applicable_to_dist_id in' ||
5844: ' ( select apdist2.invoice_distribution_id' ||
5845: ' from ap_self_assessed_tax_dist_all apdist2' ||
5846: ' where apdist2.invoice_id = :invoice_id' ||
5847: ' and apdist2.invoice_line_number = :invoice_line_number)' ||
5848: ' and apdist1.line_type_lookup_code in (''NONREC_TAX''))'; /* Bug 5403294 */
5849: ELSIF p_invoice_line_number IS NOT NULL THEN

Line 10750: CURSOR c_parent_dist_id_sat_cur(p_invoice_distribution_id AP_SELF_ASSESSED_TAX_DIST_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS

10746: FROM ap_invoice_distributions_all
10747: WHERE invoice_distribution_id = p_parent_distribution_id;
10748: /*Self Assessed Tax Changes */
10749:
10750: CURSOR c_parent_dist_id_sat_cur(p_invoice_distribution_id AP_SELF_ASSESSED_TAX_DIST_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10751: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10752: FROM ap_self_assessed_tax_dist_all
10753: WHERE invoice_distribution_id = p_invoice_distribution_id;
10754:

Line 10752: FROM ap_self_assessed_tax_dist_all

10748: /*Self Assessed Tax Changes */
10749:
10750: CURSOR c_parent_dist_id_sat_cur(p_invoice_distribution_id AP_SELF_ASSESSED_TAX_DIST_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10751: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10752: FROM ap_self_assessed_tax_dist_all
10753: WHERE invoice_distribution_id = p_invoice_distribution_id;
10754:
10755: CURSOR c_parent_line_number_sat_cur(p_parent_distribution_id AP_SELF_ASSESSED_TAX_DIST_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10756: SELECT invoice_line_number

Line 10755: CURSOR c_parent_line_number_sat_cur(p_parent_distribution_id AP_SELF_ASSESSED_TAX_DIST_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS

10751: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10752: FROM ap_self_assessed_tax_dist_all
10753: WHERE invoice_distribution_id = p_invoice_distribution_id;
10754:
10755: CURSOR c_parent_line_number_sat_cur(p_parent_distribution_id AP_SELF_ASSESSED_TAX_DIST_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10756: SELECT invoice_line_number
10757: FROM ap_self_assessed_tax_dist_all
10758: WHERE invoice_distribution_id = p_parent_distribution_id;
10759: /* Bug 5386471 - End */

Line 10757: FROM ap_self_assessed_tax_dist_all

10753: WHERE invoice_distribution_id = p_invoice_distribution_id;
10754:
10755: CURSOR c_parent_line_number_sat_cur(p_parent_distribution_id AP_SELF_ASSESSED_TAX_DIST_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10756: SELECT invoice_line_number
10757: FROM ap_self_assessed_tax_dist_all
10758: WHERE invoice_distribution_id = p_parent_distribution_id;
10759: /* Bug 5386471 - End */
10760:
10761: etax_exception EXCEPTION;

Line 11045: FROM ap_self_assessed_tax_dist_all apdist1,

11041: ,'AP DISCOUNTS','INTERCOMPANY_AP_INVOICES','INTERPROJECT_AP_INVOICES'
11042: ,'AP NRTAX','AP EXPENSE','AP ERV') /* Bug 5235354 */
11043: UNION ALL
11044: SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /*Self Assessed Tax Changes*/
11045: FROM ap_self_assessed_tax_dist_all apdist1,
11046: ap_self_assessed_tax_dist_all apdist2
11047: WHERE p_document_distribution_id = apdist1.invoice_distribution_id
11048: AND apdist1.reversal_flag = 'Y'
11049: AND apdist1.parent_reversal_id = apdist2.invoice_distribution_id

Line 11046: ap_self_assessed_tax_dist_all apdist2

11042: ,'AP NRTAX','AP EXPENSE','AP ERV') /* Bug 5235354 */
11043: UNION ALL
11044: SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /*Self Assessed Tax Changes*/
11045: FROM ap_self_assessed_tax_dist_all apdist1,
11046: ap_self_assessed_tax_dist_all apdist2
11047: WHERE p_document_distribution_id = apdist1.invoice_distribution_id
11048: AND apdist1.reversal_flag = 'Y'
11049: AND apdist1.parent_reversal_id = apdist2.invoice_distribution_id
11050: --AND apdist2.old_distribution_id IS NOT NULL

Line 11208: FROM ap_self_assessed_tax_dist_all dist

11204: RETURN TRUE;
11205: ELSE /*Self Assessed Tax Changes*/
11206: SELECT NULL
11207: INTO l_dummy
11208: FROM ap_self_assessed_tax_dist_all dist
11209: WHERE dist.invoice_distribution_id = p_invoice_distribution_id
11210: AND EXISTS (
11211: SELECT NULL
11212: FROM ap_invoice_distributions_all ppdist