APPS.OE_VALIDATE_LINE dependencies on OE_ORDER_HEADERS

Line 916: FROM oe_order_headers

912: BEGIN
913:
914: SELECT order_date_type_code
915: INTO l_order_date_type_code
916: FROM oe_order_headers
917: WHERE header_id = p_header_id;
918:
919: RETURN l_order_date_type_code;
920:

Line 1181: FROM oe_order_headers

1177: ORDER BY a.item_type_code ;
1178:
1179: CURSOR Get_Order_Type IS
1180: SELECT order_type_id
1181: FROM oe_order_headers
1182: WHERE header_id = p_line_rec.header_id ;
1183:
1184: Cursor find_config_assign is
1185: SELECT 'EXISTS'

Line 2233: oe_order_headers header

2229:
2230: SELECT wf_assign.process_name
2231: INTO l_root
2232: FROM oe_workflow_assignments wf_assign,
2233: oe_order_headers header
2234: WHERE nvl(p_wfasgn_item_type ,'-99') = nvl(wf_assign.item_type_code,nvl(p_wfasgn_item_type,'-99'))
2235: AND header.header_id = p_header_id
2236: AND header.order_type_id = wf_assign.order_type_id
2237: AND wf_assign.line_type_id = p_line_type_id

Line 6530: From oe_order_headers_all

6526: --fix a problem in which for some rare cases in which cachce has a null of transactional_curr_code
6527: If nvl(l_hdr_currency_code,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR Then
6528: Select transactional_curr_code
6529: into l_hdr_currency_code
6530: From oe_order_headers_all
6531: Where header_id = p_line_rec.header_id;
6532: End If;
6533:
6534: QP_UTIL_PUB.Validate_Price_list_Curr_code(p_line_rec.price_list_id,