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.CS_CHARGE_CORE_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 82: FROM OE_ORDER_HEADERS_ALL HD,

78:
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

Line 99: FROM OE_ORDER_HEADERS_ALL HD,

95: /*
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

Line 115: FROM oe_order_headers_all

111: -- Added to resolve Bug # 3816254
112:
113: Cursor get_order_details(p_order_header_id number) IS
114: SELECT order_number
115: FROM oe_order_headers_all
116: WHERE header_id = p_order_header_id;
117:
118: Cursor get_invoice_details(p_order_header_number NUMBER,
119: p_line_id NUMBER)IS