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

Line 249: ra_customer_trx_lines_all rctl,

245: CURSOR c_delivery(pn_customer_trx_id IN NUMBER, pn_org_id IN NUMBER)
246: IS
247: SELECT rctl.interface_line_attribute3, rctl.interface_line_attribute6
248: FROM ra_customer_trx_all trx,
249: ra_customer_trx_lines_all rctl,
250: jai_ar_trx_lines jrctl,
251: JAI_AR_TRXS jrct
252: WHERE trx.customer_trx_id = rctl.customer_trx_id
253: AND jrct.customer_trx_id = trx.customer_trx_id

Line 1533: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,

1529: WHEN OTHERS THEN
1530: p_process_status := jai_constants.unexpected_error;
1531: p_process_message := SUBSTR(SQLERRM,1,300);
1532: END insert_trx_line_gl_dist;
1533: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

Line 1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,

1530: p_process_status := jai_constants.unexpected_error;
1531: p_process_message := SUBSTR(SQLERRM,1,300);
1532: END insert_trx_line_gl_dist;
1533: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

Line 1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

1531: p_process_message := SUBSTR(SQLERRM,1,300);
1532: END insert_trx_line_gl_dist;
1533: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

Line 1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,

1532: END insert_trx_line_gl_dist;
1533: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

Line 1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,

1533: PROCEDURE insert_trx_lines(p_extended_amount IN ra_customer_trx_lines_all.extended_amount%TYPE,
1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

Line 1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,

1534: p_taxable_amount IN ra_customer_trx_lines_all.taxable_amount%TYPE,
1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

Line 1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,

1535: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

Line 1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,

1536: p_last_update_date IN ra_customer_trx_lines_all.last_update_date%TYPE,
1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

Line 1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,

1537: p_last_updated_by IN ra_customer_trx_lines_all.last_updated_by%TYPE,
1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

Line 1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,

1538: p_creation_date IN ra_customer_trx_lines_all.creation_date%TYPE,
1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

Line 1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,

1539: p_created_by IN ra_customer_trx_lines_all.created_by%TYPE,
1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

Line 1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,

1540: p_last_update_login IN ra_customer_trx_lines_all.last_update_login%TYPE,
1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

Line 1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,

1541: p_customer_trx_id IN ra_customer_trx_lines_all.customer_trx_id%TYPE,
1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

Line 1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,

1542: p_line_number IN ra_customer_trx_lines_all.line_number%TYPE,
1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,

Line 1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,

1543: p_set_of_books_id IN ra_customer_trx_lines_all.set_of_books_id%TYPE,
1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
1551: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,

Line 1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,

1544: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE,
1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
1551: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
1552: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,

Line 1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,

1545: p_line_type IN ra_customer_trx_lines_all.line_type%TYPE,
1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
1551: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
1552: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
1553: p_process_status OUT NOCOPY VARCHAR2,

Line 1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,

1546: p_org_id IN ra_customer_trx_lines_all.org_id%TYPE,
1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
1551: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
1552: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
1553: p_process_status OUT NOCOPY VARCHAR2,
1554: p_process_message OUT NOCOPY VARCHAR2)

Line 1551: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,

1547: p_uom_code IN ra_customer_trx_lines_all.uom_code%TYPE,
1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
1551: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
1552: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
1553: p_process_status OUT NOCOPY VARCHAR2,
1554: p_process_message OUT NOCOPY VARCHAR2)
1555: IS

Line 1552: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,

1548: p_autotax IN ra_customer_trx_lines_all.autotax%TYPE,
1549: p_vat_tax_id IN ra_customer_trx_lines_all.vat_tax_id%TYPE,
1550: p_interface_line_context IN ra_customer_trx_lines_all.interface_line_context%TYPE,
1551: p_interface_line_attribute6 IN ra_customer_trx_lines_all.interface_line_attribute6%TYPE,
1552: p_interface_line_attribute3 IN ra_customer_trx_lines_all.interface_line_attribute3%TYPE,
1553: p_process_status OUT NOCOPY VARCHAR2,
1554: p_process_message OUT NOCOPY VARCHAR2)
1555: IS
1556: BEGIN

Line 1560: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,

1556: BEGIN
1557: p_process_status := jai_constants.successful;
1558: p_process_message := NULL;
1559:
1560: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,
1561: taxable_amount,
1562: customer_trx_line_id,
1563: last_update_date,
1564: last_updated_by,

Line 1647: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,

1643:
1644:
1645:
1646: PROCEDURE delete_trx_data(p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
1647: p_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE DEFAULT NULL,
1648: p_process_status OUT NOCOPY VARCHAR2,
1649: p_process_message OUT NOCOPY VARCHAR2)
1650: IS
1651: /* Ramananda for bug#5219225. */

Line 1710: FROM ra_customer_trx_lines_all

1706: WHERE customer_trx_id = p_customer_trx_id
1707: AND account_class IN ('TAX','FREIGHT')
1708: AND customer_trx_line_id IN
1709: (SELECT customer_trx_line_id
1710: FROM ra_customer_trx_lines_all
1711: WHERE customer_trx_id = p_customer_trx_id
1712: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1713: AND line_type in ('TAX','FREIGHT')
1714: )

Line 1737: FROM ra_customer_trx_lines_all

1733: WHERE customer_trx_id = p_customer_trx_id
1734: AND account_class IN ('TAX','FREIGHT')
1735: AND customer_trx_line_id IN
1736: (SELECT customer_trx_line_id
1737: FROM ra_customer_trx_lines_all
1738: WHERE customer_trx_id = p_customer_trx_id
1739: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1740: AND line_type in ('TAX','FREIGHT')
1741: );

Line 1743: --delete the data from ra_customer_trx_lines_all

1739: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1740: AND line_type in ('TAX','FREIGHT')
1741: );
1742:
1743: --delete the data from ra_customer_trx_lines_all
1744: DELETE ra_customer_trx_lines_all
1745: WHERE customer_trx_id = p_customer_trx_id
1746: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1747: AND line_type IN ('TAX','FREIGHT');

Line 1744: DELETE ra_customer_trx_lines_all

1740: AND line_type in ('TAX','FREIGHT')
1741: );
1742:
1743: --delete the data from ra_customer_trx_lines_all
1744: DELETE ra_customer_trx_lines_all
1745: WHERE customer_trx_id = p_customer_trx_id
1746: AND link_to_cust_trx_line_id = NVL(p_link_to_cust_trx_line_id, link_to_cust_trx_line_id)
1747: AND line_type IN ('TAX','FREIGHT');
1748:

Line 1811: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

1807: FROM ar_payment_schedules_all
1808: WHERE customer_trx_id = cp_customer_trx_id
1809: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1810:
1811: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1812: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1813: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1814: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1815: IS

Line 1813: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,

1809: AND payment_schedule_id = NVL(cp_payment_schedule_id, payment_schedule_id);
1810:
1811: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1812: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1813: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1814: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1815: IS
1816: SELECT NVL(SUM(extended_amount),0) extended_amount,
1817: NVL(SUM(taxable_amount),0) taxable_amount

Line 1814: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)

1810:
1811: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
1812: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1813: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
1814: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1815: IS
1816: SELECT NVL(SUM(extended_amount),0) extended_amount,
1817: NVL(SUM(taxable_amount),0) taxable_amount
1818: FROM ra_customer_trx_lines_all

Line 1818: FROM ra_customer_trx_lines_all

1814: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
1815: IS
1816: SELECT NVL(SUM(extended_amount),0) extended_amount,
1817: NVL(SUM(taxable_amount),0) taxable_amount
1818: FROM ra_customer_trx_lines_all
1819: WHERE customer_trx_id = cp_customer_trx_id
1820: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)
1821: AND line_type = cp_line_type;
1822:

Line 1832: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id

1828: where customer_trx_line_id = p_customer_trx_line_id
1829: and account_class = 'REC'
1830: and latest_rec_flag = 'Y';
1831:
1832: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
1833: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1834: IS
1835: SELECT accounting_rule_id
1836: FROM ra_customer_trx_lines_all

Line 1833: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)

1829: and account_class = 'REC'
1830: and latest_rec_flag = 'Y';
1831:
1832: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
1833: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1834: IS
1835: SELECT accounting_rule_id
1836: FROM ra_customer_trx_lines_all
1837: WHERE customer_trx_line_id = cp_customer_trx_line_id;

Line 1836: FROM ra_customer_trx_lines_all

1832: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
1833: CURSOR accounting_set_cur(cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1834: IS
1835: SELECT accounting_rule_id
1836: FROM ra_customer_trx_lines_all
1837: WHERE customer_trx_line_id = cp_customer_trx_line_id;
1838:
1839: /* Ramananda for bug#5219225. */
1840: CURSOR c_proc_exists(cp_object_name user_procedures.object_name%type,

Line 1883: , cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)--Add by Xiao for POT change, reg bug#12533434

1879: --get the data from ra_cust_trx_line_gl_dist_all for customer_trx_id and account_class = 'REC'
1880: --CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE) --Comment by Chong.Lei for POT code port
1881: -- Added by Chong.Lei for POT code port begin
1882: CURSOR cur_gl_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE
1883: , cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)--Add by Xiao for POT change, reg bug#12533434
1884: -- Added by Chong.Lei for POT code port end
1885: IS
1886: SELECT gl_date
1887: FROM ra_cust_trx_line_gl_dist_all

Line 1912: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'

1908: FROM gl_sets_of_books
1909: WHERE set_of_books_id = cp_set_of_books_id
1910: );
1911:
1912: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
1913: CURSOR cur_customer_trx_lines(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1914: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1915: IS
1916: SELECT interface_line_attribute6,

Line 1914: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)

1910: );
1911:
1912: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
1913: CURSOR cur_customer_trx_lines(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
1914: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
1915: IS
1916: SELECT interface_line_attribute6,
1917: interface_line_attribute3,
1918: interface_line_context,

Line 1921: FROM ra_customer_trx_lines_all

1917: interface_line_attribute3,
1918: interface_line_context,
1919: NVL(extended_amount,0) extended_amount,
1920: NVL(taxable_amount,0) taxable_amount
1921: FROM ra_customer_trx_lines_all
1922: WHERE customer_trx_id = cp_customer_trx_id
1923: AND customer_trx_line_id = cp_customer_trx_line_id
1924: AND line_type = lv_line_type_line; --'LINE'
1925:

Line 2144: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;

2140: rec_customer_trx_lines cur_customer_trx_lines%ROWTYPE;
2141: rec_term_details cur_term_details%ROWTYPE;
2142: rec_prev_payment_schedule cur_prev_payment_schedule%ROWTYPE;
2143:
2144: ln_previous_customer_trx_id ra_customer_trx_lines_all.previous_customer_trx_id%TYPE;
2145: ln_inv_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2146: ln_cm_curr_conv_rate ra_customer_trx_all.exchange_rate%TYPE;
2147: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
2148: ln_vat_tax_id ar_vat_tax_all.vat_tax_id%TYPE;

Line 2257: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all

2253: IF p_debug = 'Y' THEN
2254: fnd_file.put_line(FND_FILE.LOG, 'Before delete_trx_data');
2255: END IF;
2256:
2257: --This procedure deletes the data from ra_cust_trx_line_gl_dist_all, ra_customer_trx_lines_all
2258: --Also deletes the MRC data from ra_cust_trx_line_gl_dist
2259: delete_trx_data(p_customer_trx_id => p_customer_trx_id,
2260: p_process_status => lv_process_status,
2261: p_process_message => lv_process_message);

Line 2310: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id

2306:
2307: FOR rec_temp IN cur_temp_lines_insert(p_customer_trx_id)
2308: LOOP
2309:
2310: --get the accounting_rule_id from ra_customer_trx_lines_all for customer_trx_line_id
2311: OPEN accounting_set_cur(rec_temp.link_to_cust_trx_line_id);
2312: FETCH accounting_set_cur INTO ln_accounting_rule_id;
2313: CLOSE accounting_set_cur;
2314:

Line 2327: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'

2323: ELSE
2324: lv_account_Set_flag := 'N';
2325: END IF;
2326:
2327: --get the data from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type = 'LINE'
2328: OPEN cur_customer_trx_lines(p_customer_trx_id,
2329: rec_temp.link_to_cust_trx_line_id);
2330: FETCH cur_customer_trx_lines INTO rec_customer_trx_lines;
2331: CLOSE cur_customer_trx_lines;

Line 2380: --This procedure inserts the data into ra_customer_trx_lines_all

2376: IF ld_gl_posted_date is NULL THEN
2377:
2378: -- #### IMPORTANT FOR R12 ENDS HERE
2379:
2380: --This procedure inserts the data into ra_customer_trx_lines_all
2381: insert_trx_lines(p_extended_amount => rec_temp.extended_amount,
2382: p_taxable_amount => ln_taxable_amount,
2383: p_customer_trx_line_id => rec_temp.customer_trx_line_id,
2384: p_last_update_date => rec_temp.last_update_date,

Line 2484: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

2480: END IF;
2481:
2482: END LOOP; --End rec_temp
2483:
2484: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
2485: OPEN cur_total_amt_trx_lines( p_customer_trx_id,
2486: NULL,
2487: lv_line_type_line);
2488: FETCH cur_total_amt_trx_lines INTO ln_old_amount,

Line 2528: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

2524:
2525: END IF;
2526: --Added by Ramananda for bug#5495711, Ends
2527:
2528: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
2529: OPEN cur_total_amt_trx_lines(p_customer_trx_id,
2530: NULL,
2531: lv_account_class_tax);
2532: FETCH cur_total_amt_trx_lines INTO ln_total_tax_amt_for_inv,

Line 2537: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type

2533: ln_taxable_amount; --this variable is not being used
2534: CLOSE cur_total_amt_trx_lines;
2535:
2536:
2537: --get the sum of extended_amount, taxable_amount from ra_customer_trx_lines_all for customer_trx_id, customer_trx_line_id and line_type
2538: OPEN cur_total_amt_trx_lines(p_customer_trx_id,
2539: NULL,
2540: lv_account_class_freight);
2541: FETCH cur_total_amt_trx_lines INTO ln_total_frt_amt_for_inv,

Line 3296: FROM RA_CUSTOMER_TRX_LINES_ALL

3292:
3293:
3294: CURSOR MAX_LINE_CUR(p_cust_link_line_id IN NUMBER, p_line_type IN VARCHAR2) IS
3295: SELECT NVL(MAX(line_number),0)
3296: FROM RA_CUSTOMER_TRX_LINES_ALL
3297: WHERE link_to_cust_trx_line_id = p_cust_link_line_id
3298: and line_type = p_line_type;
3299:
3300: /*Bug 11936630*/

Line 3316: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A, RA_CUSTOMER_TRX_LINES_ALL B, JAI_AR_TRX_INS_LINES_T C

3312: and NVL(inclusive_tax_flag,'N') = 'N'));
3313: /*Bug 11936630*/
3314: CURSOR PREVIOUS_AMOUNT_CUR IS
3315: SELECT A.AMOUNT , A.ACCTD_AMOUNT
3316: FROM RA_CUST_TRX_LINE_GL_DIST_ALL A, RA_CUSTOMER_TRX_LINES_ALL B, JAI_AR_TRX_INS_LINES_T C
3317: WHERE A.CUSTOMER_TRX_LINE_ID = B.CUSTOMER_TRX_LINE_ID
3318: AND B.LINK_TO_CUST_TRX_LINE_ID = C.LINK_TO_CUST_TRX_LINE_ID
3319: AND C.CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
3320: AND A.ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class)

Line 3347: From Ra_Customer_Trx_Lines_All

3343:
3344: /* AR Transactions with Invoicing Acctg Rules not supported by Localization, Enhancement Done on 16th NOV */
3345: Cursor accounting_set_cur IS
3346: Select accounting_rule_id
3347: From Ra_Customer_Trx_Lines_All
3348: Where Customer_Trx_Line_Id = p_link_line_id;
3349: v_accounting_rule_id Number;
3350: v_account_set_flag Char(1);
3351:

Line 3352: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is

3348: Where Customer_Trx_Line_Id = p_link_line_id;
3349: v_accounting_rule_id Number;
3350: v_account_set_flag Char(1);
3351:
3352: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
3353: Select previous_customer_trx_id
3354: from ra_customer_trx_lines_all
3355: where customer_trx_id = P_CUSTOMER_TRX_ID
3356: and line_type = p_line_type;

Line 3354: from ra_customer_trx_lines_all

3350: v_account_set_flag Char(1);
3351:
3352: Cursor prev_customer_trx_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
3353: Select previous_customer_trx_id
3354: from ra_customer_trx_lines_all
3355: where customer_trx_id = P_CUSTOMER_TRX_ID
3356: and line_type = p_line_type;
3357: --AND customer_trx_line_id = p_link_line_id; --Added this condition on 05-Apr-2002 as it should fetch only one value
3358: v_prev_customer_trx_id Number;

Line 3370: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is

3366: v_interface_line_attribute6 Varchar2(30);
3367: v_return_reference_type_code Varchar2(30);
3368: v_credit_invoice_line_id Number;
3369:
3370: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
3371: Select interface_line_attribute6
3372: From ra_customer_trx_lines_all
3373: Where customer_trx_id = p_customer_trx_id
3374: and line_type = p_line_type;

Line 3372: From ra_customer_trx_lines_all

3368: v_credit_invoice_line_id Number;
3369:
3370: Cursor line_id_cur(p_line_type ra_customer_trx_lines_all.line_type%TYPE ) is
3371: Select interface_line_attribute6
3372: From ra_customer_trx_lines_all
3373: Where customer_trx_id = p_customer_trx_id
3374: and line_type = p_line_type;
3375:
3376: Cursor Ref_type_cur(p_line_id IN Number) is

Line 3422: CURSOR cur_chk_jai_tax_dtls ( cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,

3418: ra_customer_trx_all WHERE
3419: customer_trx_id = p_customer_trx_id;
3420:
3421: --added the following cursor for bug#8476512
3422: CURSOR cur_chk_jai_tax_dtls ( cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
3423: cp_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE)
3424: IS
3425: SELECT 1
3426: FROM jai_ar_trx_tax_lines

Line 3423: cp_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE)

3419: customer_trx_id = p_customer_trx_id;
3420:
3421: --added the following cursor for bug#8476512
3422: CURSOR cur_chk_jai_tax_dtls ( cp_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE,
3423: cp_link_to_cust_trx_line_id IN ra_customer_trx_lines_all.link_to_cust_trx_line_id%TYPE)
3424: IS
3425: SELECT 1
3426: FROM jai_ar_trx_tax_lines
3427: WHERE customer_trx_line_id = cp_customer_trx_line_id

Line 3443: from Ra_customer_trx_lines_all

3439: v_taxable_amt number := 0;
3440:
3441: Cursor get_ext_amt_ln( p_line_type ra_customer_trx_lines.line_type%TYPE )
3442: is Select extended_amount
3443: from Ra_customer_trx_lines_all
3444: where customer_trx_id = P_CUSTOMER_TRX_ID
3445: and customer_trx_line_id = P_LINK_LINE_ID
3446: and line_type = p_line_type;--rchandan for bug#4428980
3447:

Line 3449: from Ra_customer_trx_lines_all

3445: and customer_trx_line_id = P_LINK_LINE_ID
3446: and line_type = p_line_type;--rchandan for bug#4428980
3447:
3448: Cursor get_ext_amt_tax is Select extended_amount,customer_trx_line_id
3449: from Ra_customer_trx_lines_all
3450: where customer_trx_id = P_CUSTOMER_TRX_ID
3451: and Link_to_cust_trx_line_id = P_LINK_LINE_ID
3452: and line_type = lv_tax_const;--rchandan for bug#4428980
3453:

Line 3457: from ra_customer_trx_lines_all

3453:
3454: get_ext_amt_tax_rec get_ext_amt_tax%rowtype;
3455:
3456: Cursor get_taxable_amt(cust_trx_ln_id number) Is Select nvl(taxable_amount,0)
3457: from ra_customer_trx_lines_all
3458: where customer_trx_line_id = cust_trx_ln_id
3459: and customer_trx_id = P_CUSTOMER_TRX_ID
3460: and line_type = lv_tax_const;--rchandan for bug#4428980
3461:

Line 3509: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,

3505: ln_tax_acctd_amount NUMBER;
3506:
3507:
3508: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
3509: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
3510: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
3511: IS
3512: SELECT NVL(SUM(extended_amount),0) extended_amount
3513: FROM ra_customer_trx_lines_all

Line 3510: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)

3506:
3507:
3508: CURSOR cur_total_amt_trx_lines( cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,
3509: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
3510: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
3511: IS
3512: SELECT NVL(SUM(extended_amount),0) extended_amount
3513: FROM ra_customer_trx_lines_all
3514: WHERE customer_trx_id = cp_customer_trx_id

Line 3513: FROM ra_customer_trx_lines_all

3509: cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%TYPE DEFAULT NULL,
3510: cp_line_type ra_customer_trx_lines_all.line_type%TYPE)
3511: IS
3512: SELECT NVL(SUM(extended_amount),0) extended_amount
3513: FROM ra_customer_trx_lines_all
3514: WHERE customer_trx_id = cp_customer_trx_id
3515: AND customer_trx_line_id = NVL(cp_customer_trx_line_id, customer_trx_line_id)
3516: AND line_type = cp_line_type;
3517:

Line 3572: tables ra_customer_trx_lines_all ,ra_cust_trx_line_gl_dist_all.

3568: 3 2002/03/22 RPK : for BUG#2285636
3569:
3570: Code modified to rollback the entire transactions if a transaction
3571: is failed.That is, the tax lines will be inserted all or none in the
3572: tables ra_customer_trx_lines_all ,ra_cust_trx_line_gl_dist_all.
3573: Also,whenever any record got errored out,then the corresponding invoice
3574: taxes will not be processed to the base table itself and that record will
3575: be updated to 'R'(column error_flag).
3576:

Line 3797: -- because this is wrong.We need to compare the ra_customer_trx_lines_all table

3793: v_sql_num :=13;
3794:
3795:
3796: -- the following select statement commented and using the next one instead
3797: -- because this is wrong.We need to compare the ra_customer_trx_lines_all table
3798: -- with the link_to_cust_trx_line_id column instead of based on the customer_trx_line_id
3799: -- column in the ra_cust_trx_line_gl_dist_all table. -- bug # 2784431
3800:
3801: /*

Line 3808: FROM ra_customer_trx_lines_all

3804: AND Account_class IN ('TAX','FREIGHT'); --Added on 09-Apr-2002 For the BUG#2303830
3805: */
3806:
3807: SELECT COUNT(Customer_trx_line_id) INTO v_rec_ctr
3808: FROM ra_customer_trx_lines_all
3809: where link_to_cust_trx_line_id = p_link_line_id
3810: and line_type in (lv_tax_const,lv_freight_acc_class); --rchandan for bug#4428980
3811:
3812:

Line 3819: FROM RA_CUSTOMER_TRX_LINES_ALL

3815: v_sql_num :=14;
3816:
3817: DELETE RA_CUST_TRX_LINE_GL_DIST_ALL
3818: WHERE CUSTOMER_TRX_LINE_ID IN (SELECT CUSTOMER_TRX_LINE_ID
3819: FROM RA_CUSTOMER_TRX_LINES_ALL
3820: WHERE LINK_TO_CUST_TRX_LINE_ID = LINK_REC.LINK_TO_CUST_TRX_LINE_ID)
3821: AND ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class); --rchandan for bug#4428980
3822:
3823: -- added for mrc -- sriram - 26/12 -- 3326394

Line 3834: FROM RA_CUSTOMER_TRX_LINES_ALL

3830: AND ACCOUNT_CLASS IN (lv_tax_const,lv_freight_acc_class) --rchandan for bug#4428980
3831: AND CUSTOMER_TRX_LINE_ID
3832: IN
3833: (SELECT CUSTOMER_TRX_LINE_ID
3834: FROM RA_CUSTOMER_TRX_LINES_ALL
3835: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
3836: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID
3837: AND LINE_TYPE IN (lv_tax_const,lv_freight_acc_class) --rchandan for bug#4428980
3838: )

Line 3862: FROM RA_CUSTOMER_TRX_LINES_ALL

3858: AND ACCOUNT_CLASS IN ('TAX','FREIGHT')
3859: AND CUSTOMER_TRX_LINE_ID
3860: IN
3861: (SELECT CUSTOMER_TRX_LINE_ID
3862: FROM RA_CUSTOMER_TRX_LINES_ALL
3863: WHERE CUSTOMER_TRX_ID = P_CUSTOMER_TRX_ID
3864: AND LINK_TO_CUST_TRX_LINE_ID = P_LINK_LINE_ID
3865: AND LINE_TYPE IN ('TAX','FREIGHT')
3866: )

Line 3874: DELETE RA_CUSTOMER_TRX_LINES_ALL

3870: */
3871:
3872: v_sql_num :=15;
3873:
3874: DELETE RA_CUSTOMER_TRX_LINES_ALL
3875: WHERE LINK_TO_CUST_TRX_LINE_ID = LINK_REC.LINK_TO_CUST_TRX_LINE_ID;
3876: v_sql_num :=16;
3877:
3878: Update Ar_Payment_Schedules_All

Line 3987: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,

3983: CLOSE c_gl_posted_date_cur ;
3984:
3985: IF ld_gl_posted_date is NULL THEN
3986:
3987: INSERT INTO RA_CUSTOMER_TRX_LINES_ALL ( extended_amount,
3988: customer_trx_line_id,
3989: last_update_date,
3990: last_updated_by,
3991: creation_date,

Line 4091: UPDATE RA_CUSTOMER_TRX_LINES_ALL

4087: END IF ; --v_gl_posted_date is null
4088: /* Modified by Ramananda for bug#4468353 due to sla uptake by AR, end */
4089:
4090: ELSE
4091: UPDATE RA_CUSTOMER_TRX_LINES_ALL
4092: SET EXTENDED_AMOUNT = TEMP_REC.EXTENDED_AMOUNT,
4093: LAST_UPDATE_DATE = TEMP_REC.LAST_UPDATE_DATE,
4094: LAST_UPDATED_BY = TEMP_REC.LAST_UPDATED_BY,
4095: CREATION_DATE = TEMP_REC.CREATION_DATE,

Line 4342: UPDATE ra_customer_trx_lines_all

4338: EXIT WHEN get_ext_amt_tax%NOTFOUND;
4339: OPEN get_taxable_amt(get_ext_amt_tax_rec.customer_trx_line_id);
4340: FETCH get_taxable_amt INTO v_taxable_amt;
4341: IF v_taxable_amt = 0 THEN
4342: UPDATE ra_customer_trx_lines_all
4343: SET Taxable_amount = (v_extended_amount_line - get_ext_amt_tax_rec.extended_amount)
4344: WHERE Customer_trx_line_id = get_ext_amt_tax_rec.customer_trx_line_id
4345: and customer_trx_id = P_CUSTOMER_TRX_ID
4346: and link_to_cust_trx_line_id = P_LINK_LINE_ID

Line 4720: ra_customer_trx_lines_all rctl

4716: FROM OE_ORDER_HEADERS_ALL oh,
4717: OE_ORDER_LINES_ALL ol,
4718: OE_TRANSACTION_TYPES_TL ot,
4719: oe_workflow_assignments owf,
4720: ra_customer_trx_lines_all rctl
4721: WHERE oh.header_id = ol.header_id
4722: AND oh.order_type_id = ot.transaction_type_id
4723: AND oh.order_type_id = owf.order_type_id
4724: AND ol.line_type_id = owf.line_type_id

Line 4738: ra_customer_trx_lines_all rctl

4734: UNION
4735: SELECT rctl.customer_trx_line_id
4736: FROM MTL_SYSTEM_ITEMS msi,
4737: JAI_OM_OE_RMA_LINES l,
4738: ra_customer_trx_lines_all rctl
4739: WHERE msi.inventory_item_id = rctl.inventory_item_id
4740: AND msi.inventory_item_id = l.inventory_item_id
4741: /*AND l.rma_line_id = rctl.interface_line_attribute6*/ /*Commented and added below by mmurtuza for bug 16181417*/
4742: AND l.rma_line_id = decode(replace(translate(rctl.interface_line_attribute6,'123456789','000000000'),'0',''),

Line 4770: ra_customer_trx_lines_all rctl

4766: FROM OE_ORDER_HEADERS_ALL oh,
4767: OE_ORDER_LINES_ALL ol,
4768: OE_TRANSACTION_TYPES_TL ot,
4769: oe_workflow_assignments owf,
4770: ra_customer_trx_lines_all rctl
4771: WHERE oh.header_id = ol.header_id
4772: AND oh.order_type_id = ot.transaction_type_id
4773: AND oh.order_type_id = owf.order_type_id
4774: AND ol.line_type_id = owf.line_type_id

Line 4788: ra_customer_trx_lines_all rctl

4784: UNION
4785: SELECT rctl.customer_trx_line_id
4786: FROM MTL_SYSTEM_ITEMS msi,
4787: JAI_OM_OE_RMA_LINES l,
4788: ra_customer_trx_lines_all rctl
4789: WHERE msi.inventory_item_id = rctl.inventory_item_id
4790: AND msi.inventory_item_id = l.inventory_item_id
4791: /*AND l.rma_line_id = rctl.interface_line_attribute6*/ /*Commented and added below by mmurtuza for bug 16181417*/
4792: AND l.rma_line_id = decode(replace(translate(rctl.interface_line_attribute6,'123456789','000000000'),'0',''),