DBA Data[Home] [Help]

APPS.IBU_ORDER_CAPTURE dependencies on OE_ORDER_HEADERS_ALL

Line 80: from OE_ORDER_HEADERS_ALL

76: l_person_id NUMBER :=FND_API.G_MISS_NUM;
77:
78: Cursor Get_order_salesrep_id (p_header_id NUMBER) IS
79: select salesrep_id
80: from OE_ORDER_HEADERS_ALL
81: where header_id = p_header_id;
82:
83: Cursor Get_person_id (p_salesrep_id NUMBER) IS
84: select person_id

Line 114: l_header_cursor_stmt := l_header_cursor_stmt || ' from oe_order_headers_all ord, OE_ORDER_SOURCES ord_src where header_id = :v_a_header_id and ord.source_document_type_id= ord_src.order_source_id(+)' ;

110: FND_MSG_PUB.Add;
111:
112:
113: l_header_cursor_stmt := 'select ord.source_document_id, ord.org_id, ord.source_document_type_id, ord.price_list_id, ord.transactional_curr_code, ord_src.name ';
114: l_header_cursor_stmt := l_header_cursor_stmt || ' from oe_order_headers_all ord, OE_ORDER_SOURCES ord_src where header_id = :v_a_header_id and ord.source_document_type_id= ord_src.order_source_id(+)' ;
115: l_header_cursor := dbms_sql.open_cursor;
116: dbms_sql.parse(l_header_cursor, l_header_cursor_stmt , dbms_sql.NATIVE);
117:
118: dbms_sql.bind_variable( l_header_cursor, ':v_a_header_id', p_header_id);