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.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_ALLOCATION_RULE_LINES

Line 5276: FROM AP_Allocation_Rule_Lines ARL,

5272: SELECT ARL.to_invoice_line_number,
5273: ARL.percentage,
5274: ARL.amount,
5275: Sum(AID.amount)
5276: FROM AP_Allocation_Rule_Lines ARL,
5277: AP_invoice_distributions_all AID
5278: WHERE ARL.invoice_id = X_invoice_id
5279: AND AID.invoice_id = X_invoice_id
5280: AND ARL.chrg_invoice_line_number = X_line_number

Line 5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;

5399: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
5400: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
5401: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number
5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
5407: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

Line 5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;

5400: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
5401: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number
5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
5407: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
5408: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;

Line 5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;

5402: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
5403: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
5404: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
5405: l_alloc_rule_line_number
5406: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
5407: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
5408: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5409: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
5410: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;

Line 5693: FROM ap_invoice_lines AIL, ap_allocation_rule_lines ARL

5689: BEGIN
5690:
5691: SELECT count(*)
5692: INTO l_count_undistributed_lines
5693: FROM ap_invoice_lines AIL, ap_allocation_rule_lines ARL
5694: WHERE AIL.invoice_id = X_invoice_id
5695: AND ARL.invoice_id = X_invoice_id
5696: AND ARL.chrg_invoice_line_number = X_line_number
5697: AND ARL.to_invoice_line_number = AIL.line_number