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_INVOICE_DISTRIBUTIONS_ALL

Line 5693: ' from ap_invoice_distributions_all apdist' ||

5689: IF p_include_related_tax_lines = 'Y' THEN
5690: where_clause := where_clause ||
5691: ' and ei.document_distribution_id in' ||
5692: ' ( select apdist.invoice_distribution_id' ||
5693: ' from ap_invoice_distributions_all apdist' ||
5694: ' where apdist.invoice_id = :invoice_id' ||
5695: ' and apdist.invoice_line_number = :invoice_line_number' ||
5696: ' union all' ||
5697: ' select apdist1.invoice_distribution_id' ||

Line 5698: ' from ap_invoice_distributions_all apdist1' ||

5694: ' where apdist.invoice_id = :invoice_id' ||
5695: ' and apdist.invoice_line_number = :invoice_line_number' ||
5696: ' union all' ||
5697: ' select apdist1.invoice_distribution_id' ||
5698: ' from ap_invoice_distributions_all apdist1' ||
5699: ' where apdist1.charge_Applicable_to_dist_id in' ||
5700: ' ( select apdist2.invoice_distribution_id' ||
5701: ' from ap_invoice_distributions_all apdist2' ||
5702: ' where apdist2.invoice_id = :invoice_id' ||

Line 5701: ' from ap_invoice_distributions_all apdist2' ||

5697: ' select apdist1.invoice_distribution_id' ||
5698: ' from ap_invoice_distributions_all apdist1' ||
5699: ' where apdist1.charge_Applicable_to_dist_id in' ||
5700: ' ( select apdist2.invoice_distribution_id' ||
5701: ' from ap_invoice_distributions_all apdist2' ||
5702: ' where apdist2.invoice_id = :invoice_id' ||
5703: ' and apdist2.invoice_line_number = :invoice_line_number)' ||
5704: ' and apdist1.line_type_lookup_code in (''NONREC_TAX'', ''TIPV'', ''TERV'', ''TRV''))'; /* Bug 5403294 */
5705: ELSIF p_invoice_line_number IS NOT NULL THEN

Line 9931: FROM ap_invoice_distributions_all

9927:
9928: /* Bug 5559214 - Start */
9929: SELECT nvl(historical_flag, 'N')
9930: INTO l_historical_flag
9931: FROM ap_invoice_distributions_all
9932: WHERE invoice_distribution_id = p_invoice_distribution_id;
9933: /* Bug 5559214 - End */
9934:
9935: END IF;

Line 10440: l_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; /* Bug 5386471 */

10436: l_return_status VARCHAR2(1);
10437: l_msg_count NUMBER;
10438: X_error_code VARCHAR2(30);
10439: l_encoded_error_message VARCHAR2(2000);
10440: l_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; /* Bug 5386471 */
10441: l_parent_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE; /* Bug 5386471 */
10442: l_ccid_changed BOOLEAN := FALSE; /* Bug 5440305 */
10443:
10444: CURSOR c_po_shipment_id_cur(p_po_distribution_id NUMBER) IS

Line 10441: l_parent_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE; /* Bug 5386471 */

10437: l_msg_count NUMBER;
10438: X_error_code VARCHAR2(30);
10439: l_encoded_error_message VARCHAR2(2000);
10440: l_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; /* Bug 5386471 */
10441: l_parent_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE; /* Bug 5386471 */
10442: l_ccid_changed BOOLEAN := FALSE; /* Bug 5440305 */
10443:
10444: CURSOR c_po_shipment_id_cur(p_po_distribution_id NUMBER) IS
10445: SELECT LINE_LOCATION_ID

Line 10450: CURSOR c_parent_distribution_id_cur(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS

10446: FROM PO_DISTRIBUTIONS
10447: WHERE PO_DISTRIBUTION_ID = p_po_distribution_id;
10448:
10449: /* Bug 5386471 - Start */
10450: CURSOR c_parent_distribution_id_cur(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10451: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10452: FROM ap_invoice_distributions_all
10453: WHERE invoice_distribution_id = p_invoice_distribution_id;
10454:

Line 10452: FROM ap_invoice_distributions_all

10448:
10449: /* Bug 5386471 - Start */
10450: CURSOR c_parent_distribution_id_cur(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10451: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10452: FROM ap_invoice_distributions_all
10453: WHERE invoice_distribution_id = p_invoice_distribution_id;
10454:
10455: CURSOR c_parent_line_number_cur(p_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10456: SELECT invoice_line_number

Line 10455: CURSOR c_parent_line_number_cur(p_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS

10451: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10452: FROM ap_invoice_distributions_all
10453: WHERE invoice_distribution_id = p_invoice_distribution_id;
10454:
10455: CURSOR c_parent_line_number_cur(p_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10456: SELECT invoice_line_number
10457: FROM ap_invoice_distributions_all
10458: WHERE invoice_distribution_id = p_parent_distribution_id;
10459: /* Bug 5386471 - End */

Line 10457: FROM ap_invoice_distributions_all

10453: WHERE invoice_distribution_id = p_invoice_distribution_id;
10454:
10455: CURSOR c_parent_line_number_cur(p_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10456: SELECT invoice_line_number
10457: FROM ap_invoice_distributions_all
10458: WHERE invoice_distribution_id = p_parent_distribution_id;
10459: /* Bug 5386471 - End */
10460:
10461: etax_exception EXCEPTION;

Line 10716: FROM ap_invoice_distributions_all apdist1, /* Bug 5561597 */

10712: SELECT DECODE(count(*),0,'N','Y')
10713: FROM pa_expenditure_items_all ei /* Bug 5561597 */
10714: WHERE ( ei.document_header_id, ei.document_distribution_id) IN
10715: ( SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /* Bug 5561597 */
10716: FROM ap_invoice_distributions_all apdist1, /* Bug 5561597 */
10717: ap_invoice_distributions_all apdist2 /* Bug 5561597 */
10718: WHERE p_document_distribution_id = apdist1.invoice_distribution_id
10719: AND apdist1.reversal_flag = 'Y'
10720: AND apdist1.parent_reversal_id = apdist2.invoice_distribution_id

Line 10717: ap_invoice_distributions_all apdist2 /* Bug 5561597 */

10713: FROM pa_expenditure_items_all ei /* Bug 5561597 */
10714: WHERE ( ei.document_header_id, ei.document_distribution_id) IN
10715: ( SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /* Bug 5561597 */
10716: FROM ap_invoice_distributions_all apdist1, /* Bug 5561597 */
10717: ap_invoice_distributions_all apdist2 /* Bug 5561597 */
10718: WHERE p_document_distribution_id = apdist1.invoice_distribution_id
10719: AND apdist1.reversal_flag = 'Y'
10720: AND apdist1.parent_reversal_id = apdist2.invoice_distribution_id
10721: AND apdist2.old_distribution_id IS NOT NULL

Line 10830: FUNCTION IsPeriodEndAccrual(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE)

10826: END RepCurrOrSecLedgerDiffCurr;
10827: /* Bug 5235354 - End */
10828:
10829: /* Bug 5381260 - Start */
10830: FUNCTION IsPeriodEndAccrual(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE)
10831: RETURN BOOLEAN IS
10832: l_accrue_on_receipt_flag PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG%TYPE;
10833: l_result BOOLEAN := TRUE;
10834:

Line 10839: , ap_invoice_distributions_all aid

10835: CURSOR c_get_accrue_on_receipt_flag IS
10836: SELECT poll.accrue_on_receipt_flag
10837: FROM po_line_locations_all poll
10838: , po_distributions_all pod
10839: , ap_invoice_distributions_all aid
10840: WHERE poll.line_location_id = pod.line_location_id
10841: AND pod.po_distribution_id = aid.po_distribution_id
10842: AND aid.invoice_distribution_id = p_invoice_distribution_id;
10843: BEGIN

Line 10858: p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE

10854: /* Bug 5381260 - End */
10855:
10856: /* Bug 5501250 - Start */
10857: FUNCTION IsRelatedToPrepayApp(
10858: p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE
10859: ) RETURN BOOLEAN IS
10860: l_dummy varchar2(1);
10861: BEGIN
10862: SELECT NULL

Line 10864: FROM ap_invoice_distributions_all dist

10860: l_dummy varchar2(1);
10861: BEGIN
10862: SELECT NULL
10863: INTO l_dummy
10864: FROM ap_invoice_distributions_all dist
10865: WHERE dist.invoice_distribution_id = p_invoice_distribution_id
10866: AND EXISTS (
10867: SELECT NULL
10868: FROM ap_invoice_distributions_all ppdist

Line 10868: FROM ap_invoice_distributions_all ppdist

10864: FROM ap_invoice_distributions_all dist
10865: WHERE dist.invoice_distribution_id = p_invoice_distribution_id
10866: AND EXISTS (
10867: SELECT NULL
10868: FROM ap_invoice_distributions_all ppdist
10869: WHERE ppdist.invoice_distribution_id = dist.charge_applicable_to_dist_id
10870: AND ppdist.line_type_lookup_code = 'PREPAY'
10871: );
10872: RETURN TRUE;