APPS.OE_INVOICE_PUB dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1037: FROM ra_customer_trx_lines_all ctl,

1033: BEGIN
1034: SELECT nvl(ctt.credit_memo_type_id, 0),
1035: ctt_credit.creation_sign
1036: INTO x_credit_memo_type_id, x_credit_creation_sign
1037: FROM ra_customer_trx_lines_all ctl,
1038: ra_customer_trx_all ct,
1039: ra_cust_trx_types_all ctt,
1040: ra_cust_trx_types_all ctt_credit
1041: WHERE ctl.customer_trx_line_id = p_line_rec.reference_customer_trx_line_id

Line 4847: FROM RA_CUSTOMER_TRX_LINES_ALL DIS,

4843: oe_debug_pub.add('l_ref_line_id'||l_ref_line_id);
4844: BEGIN
4845: SELECT dis.customer_trx_line_id
4846: INTO l_reference_line_id
4847: FROM RA_CUSTOMER_TRX_LINES_ALL DIS,
4848: RA_CUSTOMER_TRX_LINES_ALL PAR
4849: WHERE PAR.CUSTOMER_TRX_LINE_ID = L_DISCOUNTS_REC.REFERENCE_LINE_ID
4850: AND PAR.CUSTOMER_TRX_ID = DIS.CUSTOMER_TRX_ID
4851: AND DIS.INTERFACE_LINE_ATTRIBUTE6 = NVL(l_ref_line_id,DIS.INTERFACE_LINE_ATTRIBUTE6) --Bug2966839

Line 4848: RA_CUSTOMER_TRX_LINES_ALL PAR

4844: BEGIN
4845: SELECT dis.customer_trx_line_id
4846: INTO l_reference_line_id
4847: FROM RA_CUSTOMER_TRX_LINES_ALL DIS,
4848: RA_CUSTOMER_TRX_LINES_ALL PAR
4849: WHERE PAR.CUSTOMER_TRX_LINE_ID = L_DISCOUNTS_REC.REFERENCE_LINE_ID
4850: AND PAR.CUSTOMER_TRX_ID = DIS.CUSTOMER_TRX_ID
4851: AND DIS.INTERFACE_LINE_ATTRIBUTE6 = NVL(l_ref_line_id,DIS.INTERFACE_LINE_ATTRIBUTE6) --Bug2966839
4852: AND DIS.INTERFACE_LINE_ATTRIBUTE11 =

Line 5281: FROM RA_CUSTOMER_TRX_LINES_ALL FRE

5277: BEGIN
5278:
5279: SELECT FRE.customer_trx_line_id
5280: INTO l_reference_line_id
5281: FROM RA_CUSTOMER_TRX_LINES_ALL FRE
5282: WHERE FRE.LINE_TYPE IN ('LINE', 'FREIGHT')
5283: AND FRE.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
5284: AND FRE.INTERFACE_LINE_ATTRIBUTE1 = l_ref_order_number
5285: AND FRE.INTERFACE_LINE_ATTRIBUTE2 = l_ref_order_type

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

5303: IF l_reference_line_id IS NULL THEN
5304: BEGIN
5305: SELECT ra1.customer_trx_line_id
5306: INTO l_reference_line_id
5307: from ra_customer_trx_lines_all ra1, /* MOAC SQL CHANGE */
5308: ra_customer_trx_lines ra2
5309: where ra2.customer_trx_line_id = p_x_charges_rec.reference_line_id
5310: and ra1.customer_trx_id = ra2.customer_trx_id
5311: and ra1.line_type = 'FREIGHT'

Line 5785: FROM ra_customer_trx_lines_all

5781: AND interface_line_attribute11 = '0'
5782: AND NVL(interface_status, '~') <> 'P';
5783: SELECT nvl(max(interface_line_attribute5),0)
5784: INTO l_count2
5785: FROM ra_customer_trx_lines_all
5786: WHERE interface_line_context = 'ORDER ENTRY'
5787: AND interface_line_attribute1 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE1
5788: AND interface_line_attribute2 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE2
5789: AND interface_line_attribute6 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE6

Line 6358: FROM ra_customer_trx_lines_all

6354: AND interface_line_attribute11 = '0'
6355: AND NVL(interface_status, '~') <> 'P';
6356: SELECT count(*)
6357: INTO l_count2
6358: FROM ra_customer_trx_lines_all
6359: WHERE interface_line_context = 'ORDER ENTRY'
6360: AND interface_line_attribute1 = p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1
6361: AND interface_line_attribute2 = p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE2
6362: AND interface_line_attribute6= to_char(p_line_rec.line_id)

Line 6839: select ACCOUNTING_RULE_ID INTO L_ACCOUNTING_RULE_ID from RA_CUSTOMER_TRX_LINES_all

6835: p_x_interface_line_rec.Invoicing_Rule_Id := NULL;
6836: p_x_interface_line_rec.Term_Id := NULL;
6837: --bug 6324173, populate credit method only if referenced invoice has accounting rule
6838: IF p_x_interface_line_rec.Reference_Line_Id is NOT NULL THEN
6839: select ACCOUNTING_RULE_ID INTO L_ACCOUNTING_RULE_ID from RA_CUSTOMER_TRX_LINES_all
6840: where CUSTOMER_TRX_LINE_ID= p_x_interface_line_rec.Reference_Line_Id;
6841: IF L_ACCOUNTING_RULE_ID is NOT NULL THEN
6842: Get_Credit_Method_Code(p_line_rec
6843: ,p_x_interface_line_rec.Credit_Method_For_Acct_Rule

Line 6859: FROM ra_customer_trx_lines_all

6855: oe_debug_pub.add( 'REFERENCE_LINE_ID FROM COMMITMENT ID IS '||P_LINE_REC.COMMITMENT_ID ) ;
6856: END IF;
6857: SELECT customer_trx_line_id
6858: INTO p_x_interface_line_rec.Reference_Line_Id
6859: FROM ra_customer_trx_lines_all
6860: WHERE customer_trx_id = p_line_rec.Commitment_Id;
6861: -- p_x_interface_line_rec.Cust_Trx_Type_Id := NULL; -- bug 4744262
6862: END IF;
6863: IF /*p_line_rec.accounting_rule_id = 1 or*/ p_line_rec.accounting_rule_id is NULL THEN--Bug 5730802