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.CSI_INV_TXNSTUB_PKG dependencies on OE_ORDER_LINES_ALL

Line 74: (SELECT header_id FROM oe_order_lines_all WHERE line_id = pc_transaction_id));

70: WHERE source_line_ref_id = pc_transaction_id
71: AND transaction_type_id in (51,54,401)
72: AND source_header_ref IN
73: (SELECT order_number FROM oe_order_headers_all WHERE header_id IN
74: (SELECT header_id FROM oe_order_lines_all WHERE line_id = pc_transaction_id));
75:
76: r_csi_soful_exist_txns c_csi_soful_exist_txns%rowtype;
77:
78: BEGIN

Line 488: from oe_order_lines_all

484:
485: -- check if the order is linked to any other line
486: select link_to_line_id
487: into l_link_to_line_id
488: from oe_order_lines_all
489: where line_id = l_order_line_rec.order_line_id;
490:
491: if (l_link_to_line_id is not null) then
492: begin