APPS.WSH_OTM_RIQ_XML dependencies on OE_ORDER_HEADERS_ALL

Line 125: FROM oe_order_headers_all

121:
122: -- Cursor to derive the Order Header Date Type
123: CURSOR c_get_order_date_type_csr (p_header_id IN NUMBER) IS
124: SELECT NVL(order_date_type_code,'SHIP')
125: FROM oe_order_headers_all
126: WHERE header_id = p_header_id ;
127:
128: -- Cursor to derive the Order Line Date Type
129: -- Ship Date should be greatest of Sysdate and Schedule Ship Date

Line 150: l_order_date_type OE_ORDER_HEADERS_ALL.ORDER_DATE_TYPE_CODE%TYPE;

146:
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;

Line 5079: FROM oe_order_headers_all

5075: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Handle_Get_FC_Response';
5076:
5077: CURSOR c_get_currency(p_source_header_id number) IS
5078: SELECT transactional_curr_code
5079: FROM oe_order_headers_all
5080: WHERE header_id = p_source_header_id;
5081:
5082: l_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE := NULL;
5083:

Line 5082: l_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE := NULL;

5078: SELECT transactional_curr_code
5079: FROM oe_order_headers_all
5080: WHERE header_id = p_source_header_id;
5081:
5082: l_currency_code OE_ORDER_HEADERS_ALL.TRANSACTIONAL_CURR_CODE%TYPE := NULL;
5083:
5084: -- exceptions related to getting currency_code from order table
5085: ORDER_NO_HEADER_ID_ERROR EXCEPTION;
5086: ORDER_NO_CURR_ERROR EXCEPTION;