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_RETROBILL_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 621: From ra_customer_trx_lines_all a,

617: Return Number As
618:
619: Cursor Get_CI_Line_Id Is
620: Select customer_trx_line_id --customer_trx_line_id is the invoice_id
621: From ra_customer_trx_lines_all a,
622: oe_transaction_types_tl b
623: Where INTERFACE_LINE_CONTEXT= 'ORDER ENTRY'
624: and INTERFACE_LINE_ATTRIBUTE1=to_char(p_order_number) ----bug5138249
625: and INTERFACE_LINE_ATTRIBUTE2=b.name

Line 3832: from ra_customer_trx_lines_all rctl,

3828: l_trx_number ra_customer_trx_all.trx_number%TYPE;
3829:
3830: CURSOR invoice_number is
3831: select rct.trx_number
3832: from ra_customer_trx_lines_all rctl,
3833: ra_customer_trx_all rct,
3834: oe_transaction_types_tl ott
3835: where rctl.INTERFACE_LINE_CONTEXT='ORDER ENTRY' and
3836: rctl.INTERFACE_LINE_ATTRIBUTE1= l_order_number and