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.JMF_GTA_ARTRX_PROC dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 88: --| ra_customer_trx_lines_all, Change Change

84: --| l_item_inventry_id is not null in the
85: --| procedure Retrieve_AR_TRXs for bug 5224923
86: --| 12/06/2006 Shujuan Yan Modify the procedure
87: --| Retrieve_AR_TRXs, Get line_number from
88: --| ra_customer_trx_lines_all, Change Change
89: --| the token value by "fnd_message.set_token
90: --| ('NUM', l_customer_trx_line_number)"
91: --| instead of "fnd_message.set_token('NUM',
92: --| l_customer_trx_line_id)" for bug 5230712

Line 2043: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;

2039: l_rac_bill_to_customer_name Hz_Parties.PARTY_NAME%TYPE;
2040: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;
2041: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2042:
2043: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2044: l_description ra_customer_trx_lines_all.description%TYPE;
2045: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2046: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2047: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;

Line 2044: l_description ra_customer_trx_lines_all.description%TYPE;

2040: l_rac_bill_to_customer_num Hz_Cust_Accounts.ACCOUNT_NUMBER%TYPE;
2041: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2042:
2043: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2044: l_description ra_customer_trx_lines_all.description%TYPE;
2045: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2046: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2047: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2048: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;

Line 2045: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;

2041: l_bill_to_taxpayer_id Hz_Parties.JGZZ_FISCAL_CODE%TYPE;
2042:
2043: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2044: l_description ra_customer_trx_lines_all.description%TYPE;
2045: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2046: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2047: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2048: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2049: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;

Line 2046: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;

2042:
2043: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2044: l_description ra_customer_trx_lines_all.description%TYPE;
2045: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2046: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2047: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2048: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2049: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2050:

Line 2047: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;

2043: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE;
2044: l_description ra_customer_trx_lines_all.description%TYPE;
2045: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2046: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2047: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2048: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2049: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2050:
2051: --12/06/2006 Added a parameter to instore the transaction line number

Line 2049: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;

2045: l_inventory_item_id ra_customer_trx_lines_all.inventory_item_id%TYPE;
2046: l_interface_line_context ra_customer_trx_lines_all.interface_line_context%TYPE;
2047: l_uom_code ra_customer_trx_lines_all.uom_code%TYPE;
2048: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2049: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2050:
2051: --12/06/2006 Added a parameter to instore the transaction line number
2052: --by Shujuan Yan for bug 5230712
2053: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;

Line 2053: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;

2049: l_quantity_credited ra_customer_trx_lines_all.quantity_credited%TYPE;
2050:
2051: --12/06/2006 Added a parameter to instore the transaction line number
2052: --by Shujuan Yan for bug 5230712
2053: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;
2054:
2055: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;
2056:
2057: -- for get bank info by customer id

Line 2055: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;

2051: --12/06/2006 Added a parameter to instore the transaction line number
2052: --by Shujuan Yan for bug 5230712
2053: l_customer_trx_line_number ra_customer_trx_lines_all.line_number%TYPE;
2054:
2055: l_amount ra_customer_trx_lines_all.taxable_amount%TYPE;
2056:
2057: -- for get bank info by customer id
2058: l_site_use_id hz_cust_site_uses.SITE_USE_ID%TYPE;
2059: l_cust_acct_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;

Line 2110: FROM ra_customer_trx_lines_all l

2106: l.unit_selling_price,
2107: l.quantity_invoiced,
2108: l.quantity_credited,
2109: l.line_number --12/06/2006 line number,Added by Shujuan bug 5230712
2110: FROM ra_customer_trx_lines_all l
2111: WHERE l.line_type = 'LINE'
2112: AND l.customer_trx_id = l_header_id;
2113:
2114: BEGIN

Line 2355: FROM ra_customer_trx_lines_all l

2351: END IF;
2352:
2353: SELECT COUNT(*)
2354: INTO l_trx_line_num
2355: FROM ra_customer_trx_lines_all l
2356: WHERE l.customer_trx_id = l_customer_trx_id;
2357:
2358: IF l_trx_line_num = 0 THEN
2359: RAISE l_repeat_exception;

Line 3697: -- the quantity stored in different column of ra_customer_trx_lines_all.

3693: 'get_inventory_item_number end ');
3694: END IF;
3695: -- end log
3696:
3697: -- the quantity stored in different column of ra_customer_trx_lines_all.
3698: IF l_ctt_class = 'CM' THEN
3699: l_trx_line.quantity := l_quantity_credited;
3700: ELSE
3701: l_trx_line.quantity := l_quantity_invoiced;

Line 4174: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;

4170: p_attribute_column IN VARCHAR2,
4171: x_attribute_value OUT NOCOPY VARCHAR2) IS
4172: l_procedure_name VARCHAR2(50) := 'get_ra_item_model';
4173:
4174: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4175: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;

Line 4175: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;

4171: x_attribute_value OUT NOCOPY VARCHAR2) IS
4172: l_procedure_name VARCHAR2(50) := 'get_ra_item_model';
4173:
4174: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4175: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;

Line 4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;

4172: l_procedure_name VARCHAR2(50) := 'get_ra_item_model';
4173:
4174: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4175: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;

Line 4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;

4173:
4174: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4175: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;

Line 4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;

4174: l_attribute1 ra_customer_trx_lines_all.Interface_Line_Attribute1%TYPE;
4175: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;

Line 4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;

4175: l_attribute2 ra_customer_trx_lines_all.Interface_Line_Attribute2%TYPE;
4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;

Line 4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;

4176: l_attribute3 ra_customer_trx_lines_all.Interface_Line_Attribute3%TYPE;
4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;

Line 4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;

4177: l_attribute4 ra_customer_trx_lines_all.Interface_Line_Attribute4%TYPE;
4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;

Line 4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;

4178: l_attribute5 ra_customer_trx_lines_all.Interface_Line_Attribute5%TYPE;
4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;

Line 4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;

4179: l_attribute6 ra_customer_trx_lines_all.Interface_Line_Attribute6%TYPE;
4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4187: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;

Line 4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;

4180: l_attribute7 ra_customer_trx_lines_all.Interface_Line_Attribute7%TYPE;
4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4187: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4188: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;

Line 4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;

4181: l_attribute8 ra_customer_trx_lines_all.Interface_Line_Attribute8%TYPE;
4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4187: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4188: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;
4189:

Line 4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;

4182: l_attribute9 ra_customer_trx_lines_all.Interface_Line_Attribute9%TYPE;
4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4187: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4188: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;
4189:
4190: BEGIN

Line 4187: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;

4183: l_attribute10 ra_customer_trx_lines_all.Interface_Line_Attribute10%TYPE;
4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4187: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4188: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;
4189:
4190: BEGIN
4191:

Line 4188: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;

4184: l_attribute11 ra_customer_trx_lines_all.Interface_Line_Attribute11%TYPE;
4185: l_attribute12 ra_customer_trx_lines_all.Interface_Line_Attribute12%TYPE;
4186: l_attribute13 ra_customer_trx_lines_all.Interface_Line_Attribute13%TYPE;
4187: l_attribute14 ra_customer_trx_lines_all.Interface_Line_Attribute14%TYPE;
4188: l_attribute15 ra_customer_trx_lines_all.Interface_Line_Attribute15%TYPE;
4189:
4190: BEGIN
4191:
4192: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4243: FROM ra_customer_trx_lines_all l

4239: l_attribute12,
4240: l_attribute13,
4241: l_attribute14,
4242: l_attribute15
4243: FROM ra_customer_trx_lines_all l
4244: WHERE l.customer_trx_line_id = p_ra_line_id;
4245:
4246: EXCEPTION
4247: WHEN no_data_found THEN