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_INVOICES_ALL

Line 2398: FROM AP_INVOICES_ALL inv,

2394: AND dist.prepay_distribution_id is not null
2395: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2396: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2397: AND exists (SELECT NULL
2398: FROM AP_INVOICES_ALL inv,
2399: PO_VENDORS vend
2400: WHERE inv.invoice_id = DIST.invoice_id
2401: AND inv.vendor_id = vend.vendor_id
2402: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2419: FROM AP_INVOICES_ALL inv,

2415: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID
2416: and PTYPE.SYSTEM_PERSON_TYPE in ('OTHER','CWK')))
2417: ))
2418: AND exists(SELECT inv.invoice_id
2419: FROM AP_INVOICES_ALL inv,
2420: AP_Invoice_Distributions_all aid
2421: WHERE aid.invoice_id = inv.invoice_id
2422: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
2423: AND aid.historical_flag = 'Y'

Line 2450: FROM AP_INVOICES_ALL inv,

2446: AND dist.prepay_distribution_id is not null
2447: AND trunc(dist.Accounting_Date) <= trunc(nvl(G_GL_DATE,dist.Accounting_Date))
2448: AND trunc(dist.expenditure_item_date) <= trunc(nvl(G_TRANSACTION_DATE,dist.expenditure_item_date))
2449: AND exists (SELECT NULL
2450: FROM AP_INVOICES_ALL inv,
2451: PO_VENDORS vend
2452: WHERE inv.invoice_id = DIST.invoice_id
2453: AND inv.vendor_id = vend.vendor_id
2454: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2470: FROM AP_INVOICES_ALL inv,

2466: and PTYPE.PERSON_TYPE_ID = PPL.PERSON_TYPE_ID
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'

Line 2501: FROM AP_INVOICES_ALL inv,

2497: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
2498: AND DIST.project_id > 0
2499: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2500: AND exists (SELECT invoice_id
2501: FROM AP_INVOICES_ALL inv,
2502: PO_VENDORS vend
2503: WHERE inv.invoice_id = DIST.invoice_id
2504: AND inv.vendor_id = vend.vendor_id
2505: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2543: FROM AP_INVOICES_ALL inv,

2539: ('S', 'A', 'B', 'C', 'D', 'I', 'N', 'J', 'K', 'M', 'P','Q', 'V', 'X', 'W')
2540: AND DIST.project_id > 0
2541: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2542: AND exists (SELECT invoice_id
2543: FROM AP_INVOICES_ALL inv,
2544: PO_VENDORS vend
2545: WHERE inv.invoice_id = DIST.invoice_id
2546: AND inv.vendor_id = vend.vendor_id
2547: AND ((inv.invoice_type_lookup_code = G_INVOICE_TYPE

Line 2620: FROM ap_invoices_all inv,

2616: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2617: AND (
2618: EXISTS (
2619: SELECT NULL
2620: FROM ap_invoices_all inv,
2621: po_distributions_all PO,
2622: ap_invoice_distributions_all dist2
2623: WHERE inv.invoice_id = dist2.invoice_id
2624: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2642: FROM ap_invoices_all inv1,

2638: )
2639: OR
2640: EXISTS (
2641: SELECT NULL
2642: FROM ap_invoices_all inv1,
2643: ap_invoice_distributions_all dist3
2644: WHERE inv1.invoice_id = dist3.invoice_id
2645: AND inv1.invoice_id = dist.invoice_id
2646: AND inv1.invoice_type_lookup_code <> 'EXPENSE REPORT'

Line 2892: FROM ap_invoices_all inv,

2888: AND DIST.project_id = G_PROJECT_ID
2889: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2890: AND EXISTS (
2891: SELECT NULL
2892: FROM ap_invoices_all inv,
2893: po_distributions_all PO,
2894: ap_invoice_distributions_all dist2
2895: WHERE inv.invoice_id = dist2.invoice_id
2896: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 2974: FROM ap_invoices_all inv,

2970: AND DIST.project_id = G_PROJECT_ID
2971: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
2972: AND EXISTS (
2973: SELECT NULL
2974: FROM ap_invoices_all inv,
2975: po_distributions_all PO,
2976: AP_SELF_ASSESSED_TAX_DIST dist2
2977: WHERE inv.invoice_id = dist2.invoice_id
2978: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 3065: FROM ap_invoices_all inv,

3061: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
3062: AND (
3063: EXISTS (
3064: SELECT NULL
3065: FROM ap_invoices_all inv,
3066: po_distributions_all PO,
3067: ap_invoice_distributions_all dist2
3068: WHERE inv.invoice_id = dist2.invoice_id
3069: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 3178: FROM AP_INVOICES_all inv,

3174: AND inv.source not in ('CREDIT CARD','Both Pay') /* Added for bug 8977795 */
3175: AND nvl(INV.source, 'xx' ) NOT IN (
3176: 'PA_IC_INVOICES','PA_COST_ADJUSTMENTS') ) /* Removed 'Oracle Project Accounting' */
3177: AND exists(SELECT inv.invoice_id
3178: FROM AP_INVOICES_all inv,
3179: AP_Invoice_Distributions_all aid
3180: WHERE aid.invoice_id = inv.invoice_id
3181: AND inv.invoice_type_lookup_code = 'PREPAYMENT'
3182: AND aid.historical_flag = 'Y'

Line 3260: FROM AP_INVOICES_all inv,

3256: AND inv.source not in ('CREDIT CARD','Both Pay')
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*/

Line 3333: FROM ap_invoices_all inv,

3329: trunc(NVL(G_TRANSACTION_DATE, DIST.Expenditure_Item_Date)) /*GSCC*/
3330: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
3331: AND EXISTS (
3332: SELECT NULL
3333: FROM ap_invoices_all inv,
3334: po_distributions_all PO,
3335: ap_invoice_distributions_all dist2
3336: WHERE inv.invoice_id = dist2.invoice_id
3337: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 3418: FROM ap_invoices_all inv,

3414: trunc(NVL(G_TRANSACTION_DATE, DIST.Expenditure_Item_Date)) /*GSCC*/
3415: AND dist.line_type_lookup_code <> 'REC_TAX' -- do not proces recoverable tax
3416: AND EXISTS (
3417: SELECT NULL
3418: FROM ap_invoices_all inv,
3419: po_distributions_all PO,
3420: AP_SELF_ASSESSED_TAX_DIST dist2
3421: WHERE inv.invoice_id = dist2.invoice_id
3422: AND nvl(po.distribution_type,'XXX') <> 'PREPAYMENT'

Line 5344: FROM AP_INVOICES_ALL inv,

5340: FROM ap_payment_history_all hist
5341: WHERE hist.payment_history_id = dist.payment_history_id
5342: AND hist.posted_flag = 'Y')
5343: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
5344: FROM AP_INVOICES_ALL inv,
5345: AP_Invoice_Distributions_all aid,
5346: ap_invoice_payments_all aip
5347: WHERE inv.invoice_id = aip.invoice_id
5348: AND aid.invoice_id = inv.invoice_id

Line 5611: FROM AP_INVOICES_ALL inv,

5607: FROM ap_payment_history_all hist
5608: WHERE hist.payment_history_id = dist.payment_history_id
5609: AND hist.posted_flag = 'Y')
5610: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5611: FROM AP_INVOICES_ALL inv,
5612: AP_Invoice_Distributions_all aid,
5613: ap_invoice_payments_all aip
5614: WHERE inv.invoice_id = aip.invoice_id
5615: AND aid.invoice_id = inv.invoice_id

Line 5652: FROM AP_INVOICES_ALL inv,

5648: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5649: and hist.transaction_type in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5650: AND hist.posted_flag = 'Y')
5651: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5652: FROM AP_INVOICES_ALL inv,
5653: PO_Distributions_all PO,
5654: AP_Invoice_Distributions_all aid,
5655: ap_invoice_payments_all aip
5656: WHERE inv.invoice_id = aip.invoice_id

Line 5711: FROM AP_INVOICES_ALL inv,

5707: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5708: and hist.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5709: AND hist.posted_flag = 'Y')
5710: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5711: FROM AP_INVOICES_ALL inv,
5712: PO_Distributions_all PO,
5713: AP_Invoice_Distributions_all aid,
5714: ap_invoice_payments_all aip
5715: WHERE inv.invoice_id = aip.invoice_id

Line 5768: FROM AP_INVOICES_ALL inv,

5764: FROM ap_payment_history_all hist
5765: WHERE hist.payment_history_id = dist.payment_history_id
5766: AND hist.posted_flag = 'Y')
5767: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5768: FROM AP_INVOICES_ALL inv,
5769: AP_Invoice_Distributions_all aid,
5770: ap_invoice_payments_all aip
5771: WHERE inv.invoice_id = aip.invoice_id
5772: AND aid.invoice_id = inv.invoice_id

Line 5805: FROM AP_INVOICES_ALL inv,

5801: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5802: and hist.transaction_type in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5803: AND hist.posted_flag = 'Y')
5804: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5805: FROM AP_INVOICES_ALL inv,
5806: PO_Distributions_all PO,
5807: AP_Invoice_Distributions_all aid,
5808: ap_invoice_payments_all aip
5809: WHERE inv.invoice_id = aip.invoice_id

Line 5863: FROM AP_INVOICES_ALL inv,

5859: -- commented as part of Bug 10626450 and hist.transaction_type = 'PAYMENT CLEARING' /*Bug# 9266578 */
5860: and hist.transaction_type not in ( 'PAYMENT CREATED','PAYMENT CANCELLED') /* 'PAYMENT CREATED' Added as part of Bug 10626450 ,'PAYMENT CANCELLED' as part of 11703565 */
5861: AND hist.posted_flag = 'Y')
5862: AND exists(SELECT inv.invoice_id -- 11658939 hint del no_unnest
5863: FROM AP_INVOICES_ALL inv,
5864: PO_Distributions_all PO,
5865: AP_Invoice_Distributions_all aid,
5866: ap_invoice_payments_all aip
5867: WHERE inv.invoice_id = aip.invoice_id

Line 9009: ap_invoices_all ap1 /Changes for bug 7650946 -- Start /

9005: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9006: )
9007: AND ( EXISTS (SELECT NULL
9008: FROM ap_invoice_distributions_all apdist1,
9009: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start */
9010: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9011: AND ap1.invoice_id = apdist1.invoice_id /*Added for bug 7650946 */
9012: AND apdist1.po_distribution_id = dist.po_distribution_id
9013: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 9084: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start

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
9088: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 9230: ap_invoices_all ap1 /Changes for bug 7650946 -- Start /

9226: AND apdist2.line_type_lookup_code in ('ITEM','ACCRUAL','RETROACCRUAL','NONREC_TAX')
9227: )
9228: AND ( EXISTS (SELECT NULL
9229: FROM ap_invoice_distributions_all apdist1,
9230: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start */
9231: WHERE apdist1.pa_addition_flag IN ('F', 'G')
9232: AND ap1.invoice_id = apdist1.invoice_id
9233: AND apdist1.po_distribution_id = dist.po_distribution_id
9234: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 9305: ap_invoices_all ap1 /*Changes for bug 7650946 -- Start

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
9309: AND ap1.Invoice_Type_lookup_Code <> 'PREPAYMENT'

Line 10671: FROM AP_INVOICES_ALL inv,

10667: program_update_date=SYSDATE
10668: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10669: AND dist.amount <>0
10670: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10671: FROM AP_INVOICES_ALL inv,
10672: PO_VENDORS vend,
10673: PO_Distributions_all PO,
10674: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10675: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

Line 10721: FROM AP_INVOICES_ALL inv,

10717: FROM ap_payment_history_all hist
10718: WHERE hist.payment_history_id = dist.payment_history_id
10719: AND hist.posted_flag = 'Y')
10720: AND exists (SELECT inv.invoice_id
10721: FROM AP_INVOICES_ALL inv,
10722: PO_VENDORS vend,
10723: AP_Invoice_Distributions_all aid,
10724: ap_invoice_payments_all aip
10725: WHERE inv.vendor_id = vend.vendor_id

Line 10762: FROM AP_INVOICES_ALL inv,

10758: program_update_date=SYSDATE
10759: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10760: AND dist.amount <>0
10761: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10762: FROM AP_INVOICES_ALL inv,
10763: PO_VENDORS vend,
10764: PO_Distributions_all PO,
10765: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10766: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE

Line 10826: FROM AP_INVOICES_ALL inv,

10822: FROM ap_payment_history_all hist
10823: WHERE hist.payment_history_id = dist.payment_history_id
10824: AND hist.posted_flag = 'Y')
10825: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10826: FROM AP_INVOICES_ALL inv,
10827: PO_Distributions_all PO,
10828: AP_Invoice_Distributions_all aid,
10829: ap_invoice_payments_all aip
10830: WHERE inv.invoice_id = aip.invoice_id

Line 10873: FROM AP_INVOICES_ALL inv,

10869: program_update_date=SYSDATE
10870: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10871: AND dist.amount <> 0
10872: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10873: FROM AP_INVOICES_ALL inv,
10874: PO_Distributions_all PO,
10875: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10876: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10877: WHERE aid.invoice_id = inv.invoice_id

Line 10928: FROM AP_INVOICES_ALL inv,

10924: FROM ap_payment_history_all hist
10925: WHERE hist.payment_history_id = dist.payment_history_id
10926: AND hist.posted_flag = 'Y')
10927: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10928: FROM AP_INVOICES_ALL inv,
10929: PO_Distributions_all PO,
10930: AP_Invoice_Distributions_all aid,
10931: ap_invoice_payments_all aip
10932: WHERE inv.invoice_id = aip.invoice_id

Line 10975: FROM AP_INVOICES_ALL inv,

10971: program_update_date=SYSDATE
10972: WHERE nvl(dist.pa_addition_flag,'N') = 'N'
10973: AND dist.amount <> 0
10974: AND exists(SELECT /*+ no_unnest */ inv.invoice_id
10975: FROM AP_INVOICES_ALL inv,
10976: PO_Distributions_all PO,
10977: AP_Invoice_Distributions_all aid, --STD INV DIST LINE
10978: AP_Invoice_Distributions_all aid2 -- PREPAY APPL DIST LINE
10979: WHERE aid.invoice_id = inv.invoice_id