APPS.CS_CHARGE_CORE_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 83: RA_CUSTOMER_TRX_ALL TRX,

79: /* Fix bug 2901318
80: CURSOR Inv_Det(p_order_header_id number) IS
81: SELECT min(TRX.TRX_NUMBER), to_char(TRX.TRX_DATE)
82: FROM OE_ORDER_HEADERS_ALL HD,
83: RA_CUSTOMER_TRX_ALL TRX,
84: OE_ORDER_LINES_ALL L,
85: RA_CUSTOMER_TRX_LINES_ALL TRXL
86: WHERE HD.HEADER_ID = L.HEADER_ID
87: AND trxl.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'

Line 100: RA_CUSTOMER_TRX_ALL TRX,

96: -- Fix bug 2901318
97: CURSOR Inv_Det(p_order_header_id number) IS
98: SELECT min(TRX.TRX_NUMBER), to_char(TRX.TRX_DATE)
99: FROM OE_ORDER_HEADERS_ALL HD,
100: RA_CUSTOMER_TRX_ALL TRX,
101: RA_CUSTOMER_TRX_LINES_ALL TRXL,
102: oe_transaction_types_tl ottt
103: WHERE HD.HEADER_ID = p_order_header_id
104: and ottt.transaction_type_id = hd.ORDER_TYPE_ID

Line 122: FROM RA_CUSTOMER_TRX_ALL TRX

118: Cursor get_invoice_details(p_order_header_number NUMBER,
119: p_line_id NUMBER)IS
120: SELECT TRX.TRX_NUMBER,
121: TRX.TRX_DATE
122: FROM RA_CUSTOMER_TRX_ALL TRX
123: WHERE TRX.CUSTOMER_TRX_ID IN (SELECT TRXL.CUSTOMER_TRX_ID -- Bug 7117570 Changed = to IN
124: FROM RA_CUSTOMER_TRX_LINES_ALL TRXL
125: WHERE TRXL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
126: AND TRXL.INTERFACE_LINE_ATTRIBUTE1 = to_char(p_order_header_number)

Line 133: RA_CUSTOMER_TRX_ALL TRX

129: -- Fixed bug:5104595
130: /* SELECT TRX.TRX_NUMBER,
131: TRX.TRX_DATE
132: FROM RA_CUSTOMER_TRX_LINES_ALL TRXL,
133: RA_CUSTOMER_TRX_ALL TRX
134: WHERE TRXL.INTERFACE_LINE_CONTEXT = 'ORDER ENTRY'
135: AND TRXL.INTERFACE_LINE_ATTRIBUTE1 = to_char(p_order_header_number)
136: AND TRXL.INTERFACE_LINE_ATTRIBUTE6 = to_char(p_line_id)
137: AND TRX.CUSTOMER_TRX_ID = TRXL.CUSTOMER_TRX_ID; */