APPS.OE_RMA_LINE_VALIDATE dependencies on RA_CUSTOMER_TRX_LINES

Line 54: FROM RA_CUSTOMER_TRX_LINES

50: SELECT NVL(SUM(L2.ORDERED_QUANTITY - NVL(L2.CANCELLED_QUANTITY,0)), 0)
51: INTO L_INV_SUM
52: FROM SO_LINES L2
53: WHERE L2.RETURN_REFERENCE_ID IN (SELECT CUSTOMER_TRX_LINE_ID
54: FROM RA_CUSTOMER_TRX_LINES
55: WHERE INTERFACE_LINE_CONTEXT
56: = FND_PROFILE.Value_Specific('SO_SOURCE_CODE')
57: AND INTERFACE_LINE_ATTRIBUTE6
58: = TO_CHAR(P_RETURN_REFERENCE_ID))

Line 68: FROM RA_CUSTOMER_TRX_LINES

64: /* Get Original Ordered Quantity from Sales Order Line */
65:
66: SELECT TO_NUMBER(INTERFACE_LINE_ATTRIBUTE6)
67: INTO L_TEMP_LINE_ID
68: FROM RA_CUSTOMER_TRX_LINES
69: WHERE CUSTOMER_TRX_LINE_ID = P_RETURN_REFERENCE_ID;
70:
71: /* Get Original Ordered Quantity from Sales Order Line */
72: SELECT (L1.ORDERED_QUANTITY - NVL(L1.CANCELLED_QUANTITY,0))