DBA Data[Home] [Help]

APPS.OE_RETROBILL_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 622: oe_transaction_types_tl b

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
626: and INTERFACE_LINE_ATTRIBUTE6=to_char(p_line_id) --bug5138249

Line 3834: oe_transaction_types_tl ott

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
3837: rctl.INTERFACE_LINE_ATTRIBUTE2=ott.name and
3838: rctl. INTERFACE_LINE_ATTRIBUTE6= l_line_id and