DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on OE_ORDER_HEADERS

Line 892: FROM oe_order_headers

888: BEGIN
889:
890: SELECT order_date_type_code
891: INTO l_order_date_type_code
892: FROM oe_order_headers
893: WHERE header_id = p_header_id;
894:
895: RETURN l_order_date_type_code;
896:

Line 1157: FROM oe_order_headers

1153: ORDER BY a.item_type_code ;
1154:
1155: CURSOR Get_Order_Type IS
1156: SELECT order_type_id
1157: FROM oe_order_headers
1158: WHERE header_id = p_line_rec.header_id ;
1159:
1160: Cursor find_config_assign is
1161: SELECT 'EXISTS'

Line 6158: From oe_order_headers_all

6154: --fix a problem in which for some rare cases in which cachce has a null of transactional_curr_code
6155: If nvl(l_hdr_currency_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR Then
6156: Select transactional_curr_code
6157: into l_hdr_currency_code
6158: From oe_order_headers_all
6159: Where header_id = p_line_rec.header_id;
6160: End If;
6161:
6162: QP_UTIL_PUB.Validate_Price_list_Curr_code(p_line_rec.price_list_id,