DBA Data[Home] [Help]

APPS.WSH_UPGRADE_PICK_SLIP_DATA_NEW dependencies on SO_HEADERS_ALL

Line 203: FROM SO_HEADERS_ALL

199: SELECT NVL(CUSTOMER_ID,-1),
200: NVL(FOB_CODE, 'XX'),
201: NVL(FREIGHT_TERMS_CODE, 'XX'),
202: CURRENCY_CODE
203: FROM SO_HEADERS_ALL
204: WHERE HEADER_ID = x_header_id;
205:
206: CURSOR count_shipped_pls (x_header_id IN BINARY_INTEGER) IS
207: SELECT count(*)

Line 316: Init_Mesg('ERROR: Customer_Id column for header_id '|| p_order_header_id ||' in so_headers_all is NULL');

312: RETURN FAILURE;
313: END IF;
314:
315: IF (v_customer_id is NULL) THEN
316: Init_Mesg('ERROR: Customer_Id column for header_id '|| p_order_header_id ||' in so_headers_all is NULL');
317: RETURN FAILURE;
318: END IF;
319:
320: IF (p_date_shipped is NULL) THEN