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.OE_INVOICE_PUB dependencies on RA_CUSTOMER_TRX_LINES

Line 822: FROM ra_customer_trx_lines_all ctl,

818: BEGIN
819: SELECT nvl(ctt.credit_memo_type_id, 0),
820: ctt_credit.creation_sign
821: INTO x_credit_memo_type_id, x_credit_creation_sign
822: FROM ra_customer_trx_lines_all ctl,
823: ra_customer_trx_all ct,
824: ra_cust_trx_types_all ctt,
825: ra_cust_trx_types_all ctt_credit
826: WHERE ctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id

Line 4616: FROM RA_CUSTOMER_TRX_LINES_ALL DIS,

4612: oe_debug_pub.add('l_ref_line_id'||l_ref_line_id);
4613: BEGIN
4614: SELECT dis.customer_trx_line_id
4615: INTO l_reference_line_id
4616: FROM RA_CUSTOMER_TRX_LINES_ALL DIS,
4617: RA_CUSTOMER_TRX_LINES_ALL PAR
4618: WHERE PAR.CUSTOMER_TRX_LINE_ID = L_DISCOUNTS_REC.REFERENCE_LINE_ID
4619: AND PAR.CUSTOMER_TRX_ID = DIS.CUSTOMER_TRX_ID
4620: AND DIS.INTERFACE_LINE_ATTRIBUTE6 = NVL(l_ref_line_id,DIS.INTERFACE_LINE_ATTRIBUTE6) --Bug2966839

Line 4617: RA_CUSTOMER_TRX_LINES_ALL PAR

4613: BEGIN
4614: SELECT dis.customer_trx_line_id
4615: INTO l_reference_line_id
4616: FROM RA_CUSTOMER_TRX_LINES_ALL DIS,
4617: RA_CUSTOMER_TRX_LINES_ALL PAR
4618: WHERE PAR.CUSTOMER_TRX_LINE_ID = L_DISCOUNTS_REC.REFERENCE_LINE_ID
4619: AND PAR.CUSTOMER_TRX_ID = DIS.CUSTOMER_TRX_ID
4620: AND DIS.INTERFACE_LINE_ATTRIBUTE6 = NVL(l_ref_line_id,DIS.INTERFACE_LINE_ATTRIBUTE6) --Bug2966839
4621: AND DIS.INTERFACE_LINE_ATTRIBUTE11 =

Line 5037: FROM RA_CUSTOMER_TRX_LINES_ALL FRE

5033: BEGIN
5034:
5035: SELECT FRE.customer_trx_line_id
5036: INTO l_reference_line_id
5037: FROM RA_CUSTOMER_TRX_LINES_ALL FRE
5038: WHERE FRE.LINE_TYPE IN ('LINE', 'FREIGHT')
5039: AND FRE.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
5040: AND FRE.INTERFACE_LINE_ATTRIBUTE1 = l_ref_order_number
5041: AND FRE.INTERFACE_LINE_ATTRIBUTE2 = l_ref_order_type

Line 5063: from ra_customer_trx_lines_all ra1, /* MOAC SQL CHANGE */

5059: IF l_reference_line_id IS NULL THEN
5060: BEGIN
5061: SELECT ra1.customer_trx_line_id
5062: INTO l_reference_line_id
5063: from ra_customer_trx_lines_all ra1, /* MOAC SQL CHANGE */
5064: ra_customer_trx_lines ra2
5065: where ra2.customer_trx_line_id = p_x_charges_rec.reference_line_id
5066: and ra1.customer_trx_id = ra2.customer_trx_id
5067: and ra1.line_type = 'FREIGHT'

Line 5064: ra_customer_trx_lines ra2

5060: BEGIN
5061: SELECT ra1.customer_trx_line_id
5062: INTO l_reference_line_id
5063: from ra_customer_trx_lines_all ra1, /* MOAC SQL CHANGE */
5064: ra_customer_trx_lines ra2
5065: where ra2.customer_trx_line_id = p_x_charges_rec.reference_line_id
5066: and ra1.customer_trx_id = ra2.customer_trx_id
5067: and ra1.line_type = 'FREIGHT'
5068: and ra1.request_id is not null;

Line 5541: FROM ra_customer_trx_lines_all

5537: AND interface_line_attribute11 = '0'
5538: AND NVL(interface_status, '~') <> 'P';
5539: SELECT nvl(max(interface_line_attribute5),0)
5540: INTO l_count2
5541: FROM ra_customer_trx_lines_all
5542: WHERE interface_line_context = 'ORDER ENTRY'
5543: AND interface_line_attribute1 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE1
5544: AND interface_line_attribute2 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE2
5545: AND interface_line_attribute6 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE6

Line 6100: FROM ra_customer_trx_lines_all

6096: AND interface_line_attribute11 = '0'
6097: AND NVL(interface_status, '~') <> 'P';
6098: SELECT count(*)
6099: INTO l_count2
6100: FROM ra_customer_trx_lines_all
6101: WHERE interface_line_context = 'ORDER ENTRY'
6102: AND interface_line_attribute1 = p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1
6103: AND interface_line_attribute2 = p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE2
6104: AND interface_line_attribute6= to_char(p_line_rec.line_id)

Line 6566: select ACCOUNTING_RULE_ID INTO L_ACCOUNTING_RULE_ID from RA_CUSTOMER_TRX_LINES_all

6562: p_x_interface_line_rec.Invoicing_Rule_Id := NULL;
6563: p_x_interface_line_rec.Term_Id := NULL;
6564: --bug 6324173, populate credit method only if referenced invoice has accounting rule
6565: IF p_x_interface_line_rec.Reference_Line_Id is NOT NULL THEN
6566: select ACCOUNTING_RULE_ID INTO L_ACCOUNTING_RULE_ID from RA_CUSTOMER_TRX_LINES_all
6567: where CUSTOMER_TRX_LINE_ID= p_x_interface_line_rec.Reference_Line_Id;
6568: IF L_ACCOUNTING_RULE_ID is NOT NULL THEN
6569: Get_Credit_Method_Code(p_line_rec
6570: ,p_x_interface_line_rec.Credit_Method_For_Acct_Rule

Line 6586: FROM ra_customer_trx_lines_all

6582: oe_debug_pub.add( 'REFERENCE_LINE_ID FROM COMMITMENT ID IS '||P_LINE_REC.COMMITMENT_ID ) ;
6583: END IF;
6584: SELECT customer_trx_line_id
6585: INTO p_x_interface_line_rec.Reference_Line_Id
6586: FROM ra_customer_trx_lines_all
6587: WHERE customer_trx_id = p_line_rec.Commitment_Id;
6588: -- p_x_interface_line_rec.Cust_Trx_Type_Id := NULL; -- bug 4744262
6589: END IF;
6590: IF /*p_line_rec.accounting_rule_id = 1 or*/ p_line_rec.accounting_rule_id is NULL THEN--Bug 5730802