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

Line 5823: ' from ap_invoice_distributions_all apdist' ||

5819: IF p_include_related_tax_lines = 'Y' THEN
5820: where_clause := where_clause ||
5821: ' and ei.document_distribution_id in' ||
5822: ' ( select apdist.invoice_distribution_id' ||
5823: ' from ap_invoice_distributions_all apdist' ||
5824: ' where apdist.invoice_id = :invoice_id' ||
5825: ' and apdist.invoice_line_number = :invoice_line_number' ||
5826: ' union all' ||
5827: ' select apdist1.invoice_distribution_id' ||

Line 5828: ' from ap_invoice_distributions_all apdist1' ||

5824: ' where apdist.invoice_id = :invoice_id' ||
5825: ' and apdist.invoice_line_number = :invoice_line_number' ||
5826: ' union all' ||
5827: ' select apdist1.invoice_distribution_id' ||
5828: ' from ap_invoice_distributions_all apdist1' ||
5829: ' where apdist1.charge_Applicable_to_dist_id in' ||
5830: ' ( select apdist2.invoice_distribution_id' ||
5831: ' from ap_invoice_distributions_all apdist2' ||
5832: ' where apdist2.invoice_id = :invoice_id' ||

Line 5831: ' from ap_invoice_distributions_all apdist2' ||

5827: ' select apdist1.invoice_distribution_id' ||
5828: ' from ap_invoice_distributions_all apdist1' ||
5829: ' where apdist1.charge_Applicable_to_dist_id in' ||
5830: ' ( select apdist2.invoice_distribution_id' ||
5831: ' from ap_invoice_distributions_all apdist2' ||
5832: ' where apdist2.invoice_id = :invoice_id' ||
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'||

Line 9858: FROM AP_INVOICE_DISTRIBUTIONS

9854:
9855: /* this cursor get the expense type */
9856: CURSOR C_EXPENSE_TYPE_CUR(p_invoice_distribution_id NUMBER) IS
9857: SELECT WEB_PARAMETER_ID
9858: FROM AP_INVOICE_DISTRIBUTIONS
9859: WHERE INVOICE_DISTRIBUTION_ID = p_invoice_distribution_id;
9860:
9861: /* this cursor gets the old ccid and gl date */
9862: CURSOR C_OLD_CCID_AND_GL_DATE_CUR(p_expenditure_item_id NUMBER) IS

Line 10214: FROM ap_invoice_distributions_all

10210:
10211: /* Bug 5559214 - Start */
10212: SELECT nvl(historical_flag, 'N')
10213: INTO l_historical_flag
10214: FROM ap_invoice_distributions_all
10215: WHERE invoice_distribution_id = p_invoice_distribution_id;
10216: /* Bug 5559214 - End */
10217:
10218: END IF;

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

10725: l_return_status VARCHAR2(1);
10726: l_msg_count NUMBER;
10727: X_error_code VARCHAR2(30);
10728: l_encoded_error_message VARCHAR2(2000);
10729: l_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; /* Bug 5386471 */
10730: l_parent_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE; /* Bug 5386471 */
10731: l_ccid_changed BOOLEAN := FALSE; /* Bug 5440305 */
10732:
10733: CURSOR c_po_shipment_id_cur(p_po_distribution_id NUMBER) IS

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

10726: l_msg_count NUMBER;
10727: X_error_code VARCHAR2(30);
10728: l_encoded_error_message VARCHAR2(2000);
10729: l_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE; /* Bug 5386471 */
10730: l_parent_line_number AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_LINE_NUMBER%TYPE; /* Bug 5386471 */
10731: l_ccid_changed BOOLEAN := FALSE; /* Bug 5440305 */
10732:
10733: CURSOR c_po_shipment_id_cur(p_po_distribution_id NUMBER) IS
10734: SELECT LINE_LOCATION_ID

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

10735: FROM PO_DISTRIBUTIONS
10736: WHERE PO_DISTRIBUTION_ID = p_po_distribution_id;
10737:
10738: /* Bug 5386471 - Start */
10739: CURSOR c_parent_distribution_id_cur(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10740: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10741: FROM ap_invoice_distributions_all
10742: WHERE invoice_distribution_id = p_invoice_distribution_id;
10743:

Line 10741: FROM ap_invoice_distributions_all

10737:
10738: /* Bug 5386471 - Start */
10739: CURSOR c_parent_distribution_id_cur(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10740: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10741: FROM ap_invoice_distributions_all
10742: WHERE invoice_distribution_id = p_invoice_distribution_id;
10743:
10744: CURSOR c_parent_line_number_cur(p_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10745: SELECT invoice_line_number

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

10740: SELECT NVL(charge_applicable_to_dist_id,NVL(related_id, invoice_distribution_id))
10741: FROM ap_invoice_distributions_all
10742: WHERE invoice_distribution_id = p_invoice_distribution_id;
10743:
10744: CURSOR c_parent_line_number_cur(p_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10745: SELECT invoice_line_number
10746: FROM ap_invoice_distributions_all
10747: WHERE invoice_distribution_id = p_parent_distribution_id;
10748: /*Self Assessed Tax Changes */

Line 10746: FROM ap_invoice_distributions_all

10742: WHERE invoice_distribution_id = p_invoice_distribution_id;
10743:
10744: CURSOR c_parent_line_number_cur(p_parent_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE) IS
10745: SELECT invoice_line_number
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

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

11030: SELECT DECODE(count(*),0,'N','Y')
11031: FROM pa_expenditure_items_all ei /* Bug 5561597 */
11032: WHERE ( ei.document_header_id, ei.document_distribution_id) IN
11033: ( SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /* Bug 5561597 */
11034: FROM ap_invoice_distributions_all apdist1, /* Bug 5561597 */
11035: ap_invoice_distributions_all apdist2 /* Bug 5561597 */
11036: WHERE p_document_distribution_id = apdist1.invoice_distribution_id
11037: AND apdist1.reversal_flag = 'Y'
11038: AND apdist1.parent_reversal_id = apdist2.invoice_distribution_id

Line 11035: ap_invoice_distributions_all apdist2 /* Bug 5561597 */

11031: FROM pa_expenditure_items_all ei /* Bug 5561597 */
11032: WHERE ( ei.document_header_id, ei.document_distribution_id) IN
11033: ( SELECT apdist2.invoice_id, apdist2.invoice_distribution_id /* Bug 5561597 */
11034: FROM ap_invoice_distributions_all apdist1, /* Bug 5561597 */
11035: ap_invoice_distributions_all apdist2 /* Bug 5561597 */
11036: WHERE p_document_distribution_id = apdist1.invoice_distribution_id
11037: AND apdist1.reversal_flag = 'Y'
11038: AND apdist1.parent_reversal_id = apdist2.invoice_distribution_id
11039: AND apdist2.old_distribution_id IS NOT NULL

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

11155: END RepCurrOrSecLedgerDiffCurr;
11156: /* Bug 5235354 - End */
11157:
11158: /* Bug 5381260 - Start */
11159: FUNCTION IsPeriodEndAccrual(p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE)
11160: RETURN BOOLEAN IS
11161: l_accrue_on_receipt_flag PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG%TYPE;
11162: l_result BOOLEAN := TRUE;
11163:

Line 11168: , ap_invoice_distributions_all aid

11164: CURSOR c_get_accrue_on_receipt_flag IS
11165: SELECT poll.accrue_on_receipt_flag
11166: FROM po_line_locations_all poll
11167: , po_distributions_all pod
11168: , ap_invoice_distributions_all aid
11169: WHERE poll.line_location_id = pod.line_location_id
11170: AND pod.po_distribution_id = aid.po_distribution_id
11171: AND aid.invoice_distribution_id = p_invoice_distribution_id;
11172: BEGIN

Line 11187: p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE,

11183: /* Bug 5381260 - End */
11184:
11185: /* Bug 5501250 - Start */
11186: FUNCTION IsRelatedToPrepayApp(
11187: p_invoice_distribution_id AP_INVOICE_DISTRIBUTIONS_ALL.INVOICE_DISTRIBUTION_ID%TYPE,
11188: p_document_distribution_type PA_EXPENDITURE_ITEMS_ALL.DOCUMENT_DISTRIBUTION_TYPE%TYPE DEFAULT NULL /*Bug 13906739: Added NULL as default parameter Value*/
11189: ) RETURN BOOLEAN IS
11190: l_dummy varchar2(1);
11191: BEGIN

Line 11196: FROM ap_invoice_distributions_all dist

11192:
11193: IF p_document_distribution_type <> 'SELF_ASSESSED_TAX' then /*Self Assessed Tax Changes*/
11194: SELECT NULL
11195: INTO l_dummy
11196: FROM ap_invoice_distributions_all dist
11197: WHERE dist.invoice_distribution_id = p_invoice_distribution_id
11198: AND EXISTS (
11199: SELECT NULL
11200: FROM ap_invoice_distributions_all ppdist

Line 11200: FROM ap_invoice_distributions_all ppdist

11196: FROM ap_invoice_distributions_all dist
11197: WHERE dist.invoice_distribution_id = p_invoice_distribution_id
11198: AND EXISTS (
11199: SELECT NULL
11200: FROM ap_invoice_distributions_all ppdist
11201: WHERE ppdist.invoice_distribution_id = dist.charge_applicable_to_dist_id
11202: AND ppdist.line_type_lookup_code = 'PREPAY'
11203: );
11204: RETURN TRUE;

Line 11212: FROM ap_invoice_distributions_all ppdist

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
11213: WHERE ppdist.invoice_distribution_id = dist.charge_applicable_to_dist_id
11214: AND ppdist.line_type_lookup_code = 'PREPAY'
11215: );
11216: END IF;