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

Line 899: UPDATE ap_self_assessed_tax_dist_all DIST

895: AND ei.transaction_source in ('AP INVOICE','AP VARIANCE','AP NRTAX','AP EXPENSE')) ;
896:
897:
898: /*Bug 13602288: Self Assessed Tax Changes - Marking the SAT Lines also to N in the cleanup*/
899: UPDATE ap_self_assessed_tax_dist_all DIST
900: SET DIST.pa_addition_flag = 'N'
901: , DIST.request_id = G_REQUEST_ID
902: WHERE DIST.pa_addition_flag IN ('O','W')
903: AND DIST.posted_flag||''= 'Y'

Line 1797: FROM ap_self_assessed_tax_dist_All

1793: WHERE invoice_distribution_id = p_prepay_dist_id;
1794: else
1795: SELECT prepay_amount_remaining
1796: INTO l_prepay_rem_amt
1797: FROM ap_self_assessed_tax_dist_All
1798: WHERE invoice_distribution_id = p_prepay_dist_id;
1799: end if;
1800: -- ==================================================================================
1801: -- Bug: 5393523

Line 2076: UPDATE ap_self_assessed_tax_dist_all dist

2072: G_DISTRIBUTIONS_MARKED := nvl(G_DISTRIBUTIONS_MARKED,0) + SQL%ROWCOUNT;
2073: write_log(LOG, 'Number of Historical PREPAY Appl Dist marked to O: ' || to_char(SQL%ROWCOUNT));
2074:
2075: /*Bug 13602288: Self Assessed Tax Changes*/
2076: UPDATE ap_self_assessed_tax_dist_all dist
2077: SET dist.pa_addition_flag = 'O',
2078: request_id = G_REQUEST_ID,
2079: last_update_date=SYSDATE,
2080: last_updated_by= G_USER_ID,

Line 2116: ap_self_assessed_tax_dist_all aid

2112: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID
2113: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))))
2114: AND exists(SELECT inv.invoice_id
2115: FROM AP_INVOICES inv,
2116: ap_self_assessed_tax_dist_all aid
2117: WHERE aid.invoice_id = inv.invoice_id
2118: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2119: --aND aid.historical_flag = 'Y'
2120: AND aid.pa_addition_flag = 'Y'

Line 2471: ap_self_assessed_tax_dist_all aid

2467: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2468: ))
2469: AND exists(SELECT inv.invoice_id
2470: FROM AP_INVOICES_ALL inv,
2471: ap_self_assessed_tax_dist_all aid
2472: WHERE aid.invoice_id = inv.invoice_id
2473: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2474: --AND aid.historical_flag = 'Y'
2475: AND aid.pa_addition_flag = 'Y'

Line 2792: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL dist

2788: Pre Rel12 Upgrade should also be brought into Projects */
2789:
2790: write_log(LOG, 'Marking PREPAYMENT Self Assessed Tax lines in Cash Based Acctng');
2791:
2792: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL dist
2793: SET dist.pa_addition_flag = 'O',
2794: request_id = G_REQUEST_ID,
2795: last_update_date=SYSDATE,
2796: last_updated_by= G_USER_ID,

Line 2820: AP_SELF_ASSESSED_TAX_DIST_ALL aid

2816: AND nvl(INV.source, 'xx' ) NOT IN (
2817: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') )
2818: AND exists(SELECT inv.invoice_id
2819: FROM AP_INVOICES inv,
2820: AP_SELF_ASSESSED_TAX_DIST_ALL aid
2821: WHERE aid.invoice_id = inv.invoice_id
2822: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2823: -- AND aid.historical_flag = 'Y' /*doubt*/
2824: AND aid.pa_addition_flag = 'Y'

Line 2844: AP_SELF_ASSESSED_TAX_DIST_ALL apdist,

2840: )
2841: )
2842: AND NOT EXISTS (SELECT 'X'
2843: FROM
2844: AP_SELF_ASSESSED_TAX_DIST_ALL apdist,
2845: po_distributions pod,
2846: mtl_system_items si,
2847: po_lines_all pol
2848: where DIST.CHARGE_APPLICABLE_TO_DIST_ID

Line 3234: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL dist

3230: Pre Rel12 Upgrade should also be brought into Projects */
3231:
3232: write_log(LOG, 'Marking Historical Self Assessed Tax Prepayments for processing...');
3233:
3234: UPDATE AP_SELF_ASSESSED_TAX_DIST_ALL dist
3235: SET dist.pa_addition_flag = 'O',
3236: request_id = G_REQUEST_ID,
3237: last_update_date=SYSDATE,
3238: last_updated_by= G_USER_ID,

Line 3261: AP_SELF_ASSESSED_TAX_DIST_ALL aid

3257: AND nvl(INV.source, 'xx' ) NOT IN (
3258: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') )
3259: AND exists(SELECT inv.invoice_id
3260: FROM AP_INVOICES_all inv,
3261: AP_SELF_ASSESSED_TAX_DIST_ALL aid
3262: WHERE aid.invoice_id = inv.invoice_id
3263: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
3264: -- AND aid.historical_flag = 'Y' /*doubt*/
3265: AND aid.pa_addition_flag = 'Y'

Line 3285: AP_SELF_ASSESSED_TAX_DIST_ALL apdist,

3281: )
3282: )
3283: AND NOT EXISTS (SELECT 'X'
3284: FROM
3285: AP_SELF_ASSESSED_TAX_DIST_ALL apdist,
3286: po_distributions pod,
3287: mtl_system_items si,
3288: po_lines_all pol
3289: where DIST.CHARGE_APPLICABLE_TO_DIST_ID

Line 5297: UPDATE ap_self_assessed_tax_dist_all dist

5293:
5294: /*Bug 13602288: Self Assessed Tax Changes*/
5295: FORALL i IN l_sys_ref1_tbl.FIRST..l_sys_ref1_tbl.LAST
5296:
5297: UPDATE ap_self_assessed_tax_dist_all dist
5298: SET dist.pa_addition_flag = l_pa_addflag_tbl(i)
5299: ,dist.assets_addition_flag = decode(l_assets_addflag_tbl(i),'P','P',dist.assets_addition_flag)
5300: WHERE dist.invoice_id = l_sys_ref2_tbl(i)
5301: AND dist.invoice_distribution_id = l_sys_ref5_tbl(i)

Line 9048: UPDATE ap_self_assessed_tax_dist_all apdist

9044: write_log(LOG,'Number of inv amount variance lines marked to G: '||to_char(SQL%ROWCOUNT));
9045: write_log(LOG,'Number of inv amount variance lines marked to W: '||G_NUM_AP_VARIANCE_MARKED_W);
9046:
9047: /*Commented out for bBug 13602288: Self Assessed Tax Changes
9048: UPDATE ap_self_assessed_tax_dist_all apdist
9049: SET apdist.pa_addition_flag = DECODE(NVL(apdist.amount_variance,0),0,'G',increment_W_count('W')),
9050: request_id = G_REQUEST_ID,
9051: last_update_date=SYSDATE,
9052: last_updated_by=G_USER_ID,

Line 9059: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist

9055: program_application_id= G_PROG_APPL_ID,
9056: program_update_date=SYSDATE
9057: WHERE rowid IN (
9058: SELECT dist.rowid
9059: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist
9060: WHERE inv.invoice_id = dist.invoice_id
9061: AND (dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9062: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9063: AND EXISTS (SELECT 'X'

Line 9076: FROM ap_self_assessed_tax_dist_all apdist2

9072: AND si.organization_id = po_dist1.org_id)
9073: )
9074: ) --Bug#5399352. Added this here to take care of IPV/TIPV records matched to EIB item PO.
9075: AND NOT EXISTS (SELECT NULL
9076: FROM ap_self_assessed_tax_dist_all apdist2
9077: WHERE apdist2.pa_addition_flag = 'Y'
9078: AND apdist2.po_distribution_id = dist.po_distribution_id
9079: AND apdist2.line_type_lookup_code = dist.line_type_lookup_code
9080: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')

Line 9083: FROM ap_self_assessed_tax_dist_all apdist1,

9079: AND apdist2.line_type_lookup_code = dist.line_type_lookup_code
9080: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9081: )
9082: AND ( EXISTS (SELECT NULL
9083: FROM ap_self_assessed_tax_dist_all apdist1,
9084: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start
9085: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9086: AND ap1.invoice_id = apdist1.invoice_id /*Added for bug 7650946
9087: AND apdist1.po_distribution_id = dist.po_distribution_id

Line 9270: UPDATE ap_self_assessed_tax_dist_all apdist

9266: write_log(LOG,'Number of inv amount variance lines marked to W: '||G_NUM_AP_VARIANCE_MARKED_W);
9267:
9268:
9269: /*Commented for Bug 13602288: Self Assessed Tax Changes
9270: UPDATE ap_self_assessed_tax_dist_all apdist
9271: SET apdist.pa_addition_flag = DECODE(NVL(apdist.amount_variance,0),0,'G',increment_W_count('W')),
9272: request_id = G_REQUEST_ID,
9273: last_update_date=SYSDATE,
9274: last_updated_by=G_USER_ID,

Line 9281: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist

9277: program_application_id= G_PROG_APPL_ID,
9278: program_update_date=SYSDATE
9279: WHERE rowid IN (
9280: SELECT dist.rowid
9281: FROM ap_invoices inv, ap_self_assessed_tax_dist_all dist
9282: WHERE inv.invoice_id = dist.invoice_id
9283: AND ( dist.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9284: OR ( pa_nl_installed.is_nl_installed = 'Y' --EIB trackable items
9285: AND EXISTS (SELECT 'X'

Line 9298: FROM ap_self_assessed_tax_dist_all apdist2

9294: AND si.organization_id = po_dist1.org_id)
9295: )
9296: ) --Bug#5399352. Added this here to take care of IPV/TIPV records matched to EIB item PO.
9297: AND NOT EXISTS (SELECT NULL
9298: FROM ap_self_assessed_tax_dist_all apdist2
9299: WHERE apdist2.pa_addition_flag = 'Y'
9300: AND apdist2.po_distribution_id = dist.po_distribution_id
9301: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9302: )

Line 9304: FROM ap_self_assessed_tax_dist_all apdist1,

9300: AND apdist2.po_distribution_id = dist.po_distribution_id
9301: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9302: )
9303: AND ( EXISTS (SELECT NULL
9304: FROM ap_self_assessed_tax_dist_all apdist1,
9305: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start
9306: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9307: AND ap1.invoice_id = apdist1.invoice_id
9308: AND apdist1.po_distribution_id = dist.po_distribution_id