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

Line 142: FROM oe_order_lines_all

138: 'ARRIVAL',GREATEST(SYSDATE, NVL(schedule_arrival_date, request_date)),
139: NULL) arrival_date,
140: schedule_ship_date,
141: schedule_arrival_date
142: FROM oe_order_lines_all
143: WHERE line_id = p_line_id;
144:
145: -- End of Cursor declaration Section
146:

Line 151: l_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;

147: -- Variable declaration Section
148: l_line_index NUMBER;
149: l_header_index NUMBER;
150: l_order_date_type OE_ORDER_HEADERS_ALL.ORDER_DATE_TYPE_CODE%TYPE;
151: l_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
152: l_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
153: l_schedule_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
154: l_schedule_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
155:

Line 152: l_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;

148: l_line_index NUMBER;
149: l_header_index NUMBER;
150: l_order_date_type OE_ORDER_HEADERS_ALL.ORDER_DATE_TYPE_CODE%TYPE;
151: l_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
152: l_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
153: l_schedule_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
154: l_schedule_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
155:
156: l_debug_on BOOLEAN;

Line 153: l_schedule_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;

149: l_header_index NUMBER;
150: l_order_date_type OE_ORDER_HEADERS_ALL.ORDER_DATE_TYPE_CODE%TYPE;
151: l_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
152: l_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
153: l_schedule_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
154: l_schedule_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
155:
156: l_debug_on BOOLEAN;
157: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DERIVE_RIQ_DATES';

Line 154: l_schedule_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;

150: l_order_date_type OE_ORDER_HEADERS_ALL.ORDER_DATE_TYPE_CODE%TYPE;
151: l_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
152: l_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
153: l_schedule_ship_date OE_ORDER_LINES_ALL.SCHEDULE_SHIP_DATE%TYPE;
154: l_schedule_arrival_date OE_ORDER_LINES_ALL.SCHEDULE_ARRIVAL_DATE%TYPE;
155:
156: l_debug_on BOOLEAN;
157: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DERIVE_RIQ_DATES';
158: