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_R11_PREPAY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 253: * -- Step 3p : case p : Prepayment: Insert AP_INVOICE_DISTRIBUTIONS (ITEM)

249: X_last_update_login,
250: Current_calling_sequence);
251:
252: /*--------------------------------------------------------------------------
253: * -- Step 3p : case p : Prepayment: Insert AP_INVOICE_DISTRIBUTIONS (ITEM)
254: * Call appp_insert_invoice_dist:
255: * Create reversing ITEM distribution on the Prepayment, We presume dist line 1
256: * is item line. (converse for unapplication (amount_apply < 0) )
257: *--------------------------------------------------------------------------*/

Line 277: * -- Step 4p : case p : Prepayment: Insert AP_INVOICE_DISTRIBUTIONS (TAX)

273: Current_calling_sequence);
274:
275:
276: /*--------------------------------------------------------------------------
277: * -- Step 4p : case p : Prepayment: Insert AP_INVOICE_DISTRIBUTIONS (TAX)
278: * Call appp_insert_invoice_dist:
279: * Create reversing TAX distribution on the Prepayment if applicable,
280: * we presume dist line 2 is tax line. (converse for unapplication)
281: *--------------------------------------------------------------------------*/

Line 460: | X_dist_item_amount | No | (ap_invoice_distributions.amount / |

456: +---------------------------------------------------------------------+
457: | X_orig_amount | No | original_prepayment_amount from |
458: | | | ap_invoice.(0 if NULL) |
459: +---------------------------------------------------------------------+
460: | X_dist_item_amount | No | (ap_invoice_distributions.amount / |
461: | | | ap_invoices.original_prepayment_amount)
462: | | | * X_amount_apply |
463: +---------------------------------------------------------------------+
464: | X_dist_tax_amount | No | X_amount_apply - X_dist_item_amount |

Line 742: -- Go to base tables AP_INVIOCES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL ( only for D2 )

738:
739: debug_info := 'Get orig_amount, dist_item_amount, and dist_tax_amount';
740:
741: -- Perf bug 5058989
742: -- Go to base tables AP_INVIOCES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL ( only for D2 )
743: -- to eliminate MJC and reduce shared memory usage
744:
745: SELECT nvl(I.original_prepayment_amount,0),
746: ap_utilities_pkg.ap_round_precision(

Line 760: FROM ap_invoices_all I, ap_invoice_distributions D1,

756: C_pay_curr_min_unit, C_pay_curr_precision)))
757: INTO X_orig_amount,
758: X_dist_item_amount,
759: X_dist_tax_amount
760: FROM ap_invoices_all I, ap_invoice_distributions D1,
761: ap_invoice_distributions_all D2
762: WHERE I.invoice_id = X_prepay_id
763: AND D1.invoice_id = I.invoice_id
764: AND D1.distribution_line_number = 1

Line 761: ap_invoice_distributions_all D2

757: INTO X_orig_amount,
758: X_dist_item_amount,
759: X_dist_tax_amount
760: FROM ap_invoices_all I, ap_invoice_distributions D1,
761: ap_invoice_distributions_all D2
762: WHERE I.invoice_id = X_prepay_id
763: AND D1.invoice_id = I.invoice_id
764: AND D1.distribution_line_number = 1
765: AND D2.invoice_id(+) = D1.invoice_id -- Perf bug 5058989 -- replace I. with D1.

Line 770: -- Get max_dist from ap_invoice_distributions

766: AND D2.distribution_line_number(+) = 2;
767:
768:
769: ---------------------------------------------------------------------
770: -- Get max_dist from ap_invoice_distributions
771: ---------------------------------------------------------------------
772: debug_info := 'Get max_dist';
773: SELECT max(distribution_line_number),max(distribution_line_number)
774: INTO X_max_dist, X_orig_max_dist

Line 775: FROM ap_invoice_distributions

771: ---------------------------------------------------------------------
772: debug_info := 'Get max_dist';
773: SELECT max(distribution_line_number),max(distribution_line_number)
774: INTO X_max_dist, X_orig_max_dist
775: FROM ap_invoice_distributions
776: WHERE invoice_id = X_prepay_id;
777:
778:
779: ---------------------------------------------------------------------

Line 1030: SELECT ap_invoice_distributions_s.NEXTVAL

1026: X_max_dist := X_max_dist + 1;
1027: new_line_num := X_max_dist;
1028:
1029: /* First get the Invoice_Distribution_Id from the sequence */
1030: SELECT ap_invoice_distributions_s.NEXTVAL
1031: INTO l_invoice_distribution_id
1032: FROM sys.dual; -- added for Invoice_Distribution_Id
1033:
1034:

Line 1035: debug_info := 'Update ap_invoice_distributions for creating the distribution reversals';

1031: INTO l_invoice_distribution_id
1032: FROM sys.dual; -- added for Invoice_Distribution_Id
1033:
1034:
1035: debug_info := 'Update ap_invoice_distributions for creating the distribution reversals';
1036:
1037: INSERT INTO AP_INVOICE_DISTRIBUTIONS
1038: (invoice_id,
1039: dist_code_combination_id,

Line 1037: INSERT INTO AP_INVOICE_DISTRIBUTIONS

1033:
1034:
1035: debug_info := 'Update ap_invoice_distributions for creating the distribution reversals';
1036:
1037: INSERT INTO AP_INVOICE_DISTRIBUTIONS
1038: (invoice_id,
1039: dist_code_combination_id,
1040: last_update_date,
1041: last_updated_by,

Line 1122: FROM ap_invoice_distributions

1118: tax_code_override_flag,
1119: tax_recovery_override_flag,
1120: tax_recoverable_flag,
1121: org_id /* Bug 3700128. MOAC Project */
1122: FROM ap_invoice_distributions
1123: WHERE invoice_id = X_prepay_id
1124: AND distribution_line_number = X_copy_dist_num;
1125:
1126: --Bug 4539462 DBI logging

Line 1128: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',

1124: AND distribution_line_number = X_copy_dist_num;
1125:
1126: --Bug 4539462 DBI logging
1127: AP_DBI_PKG.Maintain_DBI_Summary
1128: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
1129: p_operation => 'I',
1130: p_key_value1 => X_prepay_id,
1131: p_key_value2 => l_invoice_distribution_Id,
1132: p_calling_sequence => current_calling_sequence);

Line 1984: UPDATE ap_invoice_distributions AID

1980: -------------------------------------------------------------------------------
1981: -- Update the reversal flag
1982: -------------------------------------------------------------------------------
1983:
1984: UPDATE ap_invoice_distributions AID
1985: SET reversal_flag = 'Y'
1986: WHERE AID.line_type_lookup_code = 'ITEM'
1987: AND AID.distribution_line_number > 1
1988: AND AID.invoice_id = X_prepay_id;

Line 2003: FROM ap_invoice_distributions

1999: -------------------------------------------------------------------------------
2000:
2001: SELECT prepay_amount_remaining
2002: INTO l_prepay_amt_remaining
2003: FROM ap_invoice_distributions
2004: WHERE invoice_id = X_prepay_id
2005: AND distribution_line_number = 1
2006: AND line_type_lookup_code = 'ITEM';
2007:

Line 2009: UPDATE ap_invoice_distributions AID

2005: AND distribution_line_number = 1
2006: AND line_type_lookup_code = 'ITEM';
2007:
2008: IF ( l_prepay_amt_remaining IS null ) THEN
2009: UPDATE ap_invoice_distributions AID
2010: SET prepay_amount_remaining = (
2011: SELECT sum(AID2.amount)
2012: FROM ap_invoice_distributions AID2
2013: WHERE AID.invoice_id = AID2.invoice_id

Line 2012: FROM ap_invoice_distributions AID2

2008: IF ( l_prepay_amt_remaining IS null ) THEN
2009: UPDATE ap_invoice_distributions AID
2010: SET prepay_amount_remaining = (
2011: SELECT sum(AID2.amount)
2012: FROM ap_invoice_distributions AID2
2013: WHERE AID.invoice_id = AID2.invoice_id
2014: AND AID2.line_type_lookup_code = 'ITEM')
2015: WHERE invoice_id = X_prepay_id
2016: AND AID.distribution_line_number = 1;

Line 2018: UPDATE ap_invoice_distributions

2014: AND AID2.line_type_lookup_code = 'ITEM')
2015: WHERE invoice_id = X_prepay_id
2016: AND AID.distribution_line_number = 1;
2017: ELSE
2018: UPDATE ap_invoice_distributions
2019: SET prepay_amount_remaining = l_prepay_amt_remaining - X_amount_apply
2020: WHERE invoice_id = X_prepay_id
2021: AND distribution_line_number = 1;
2022: END IF;