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 6638: FROM AP_Allocation_Rule_Lines ARL,

6634: SELECT ARL.to_invoice_line_number,
6635: ARL.percentage,
6636: ARL.amount,
6637: Sum(AID.amount)
6638: FROM AP_Allocation_Rule_Lines ARL,
6639: AP_invoice_distributions_all AID
6640: WHERE ARL.invoice_id = X_invoice_id
6641: AND AID.invoice_id = X_invoice_id
6642: AND ARL.chrg_invoice_line_number = X_line_number

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

6761: l_dist_tab AP_INVOICE_LINES_PKG.dist_tab_type;
6762: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
6763: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
6767: l_alloc_rule_line_number
6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

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

6762: l_alloc_line_tab AP_INVOICE_LINES_PKG.alloc_line_tab_type;
6763: l_rule_type AP_ALLOCATION_RULES.RULE_TYPE%TYPE;
6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
6767: l_alloc_rule_line_number
6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;

Line 6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;

6764: l_rule_status AP_ALLOCATION_RULES.STATUS%TYPE;
6765: l_alloc_rule_line_percent AP_ALLOCATION_RULE_LINES.PERCENTAGE%TYPE := 0;
6766: l_alloc_rule_line_amount AP_ALLOCATION_RULE_LINES.AMOUNT%TYPE := 0;
6767: l_alloc_rule_line_number
6768: AP_ALLOCATION_RULE_LINES.TO_INVOICE_LINE_NUMBER%TYPE;
6769: l_applicable_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
6770: l_applicable_line_amount AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6771: l_sum_applic_lines AP_INVOICE_LINES.AMOUNT%TYPE := 0;
6772: l_sum_dists_applic_line AP_INVOICE_DISTRIBUTIONS.AMOUNT%TYPE := 0;

Line 7130: FROM ap_invoice_lines AIL, ap_allocation_rule_lines ARL

7126: BEGIN
7127:
7128: SELECT count(*)
7129: INTO l_count_undistributed_lines
7130: FROM ap_invoice_lines AIL, ap_allocation_rule_lines ARL
7131: WHERE AIL.invoice_id = X_invoice_id
7132: AND ARL.invoice_id = X_invoice_id
7133: AND ARL.chrg_invoice_line_number = X_line_number
7134: AND ARL.to_invoice_line_number = AIL.line_number