APPS.OE_RETROBILL_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 234: OE_ORDER_HEADERS_ALL h

230: , h.Order_Type_Id
231: , t.value PLSQL_TBL_INDEX
232: FROM OM_ID_LIST_TMP t,
233: OE_ORDER_LINES_ALL l,
234: OE_ORDER_HEADERS_ALL h
235: WHERE l.line_id = t.key_id
236: AND l.header_id = h.header_id
237: ORDER BY sold_to_org_id1,h.transactional_curr_code,h.conversion_type_code;
238:

Line 536: FROM oe_order_headers_all

532: EXCEPTION
533: WHEN NO_DATA_FOUND THEN
534: BEGIN
535: SELECT order_number INTO l_order_number
536: FROM oe_order_headers_all
537: WHERE header_id=p_header_id;
538:
539: l_line_no := OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(p_line_id);
540: EXCEPTION

Line 3478: FROM oe_order_headers_all

3474:
3475: BEGIN
3476:
3477: SELECT price_list_id INTO l_header_price_list_id
3478: FROM oe_order_headers_all
3479: WHERE header_id=lx_header_id;
3480:
3481: IF ((G_FIRST_LINE_DELETED='Y' AND
3482: G_FIRST_LINE_PL_ASSIGNED='Y' AND

Line 3486: UPDATE oe_order_headers_all

3482: G_FIRST_LINE_PL_ASSIGNED='Y' AND
3483: G_FIRST_LINE_PRICE_LIST_ID IS NOT NULL) OR
3484: (l_header_price_list_id IS NULL)) THEN
3485: BEGIN
3486: UPDATE oe_order_headers_all
3487: SET price_list_id=G_FIRST_LINE_PRICE_LIST_ID
3488: WHERE header_id=lx_header_id;
3489: EXCEPTION
3490: WHEN NO_DATA_FOUND THEN

Line 3601: FROM oe_order_headers_all

3597: End If;
3598: BEGIN
3599:
3600: SELECT price_list_id INTO l_header_price_list_id
3601: FROM oe_order_headers_all
3602: WHERE header_id=lx_header_id;
3603:
3604: IF ((G_FIRST_LINE_DELETED='Y' AND
3605: G_FIRST_LINE_PL_ASSIGNED='Y' AND

Line 3609: UPDATE oe_order_headers_all

3605: G_FIRST_LINE_PL_ASSIGNED='Y' AND
3606: G_FIRST_LINE_PRICE_LIST_ID IS NOT NULL) OR
3607: (l_header_price_list_id IS NULL)) THEN
3608: BEGIN
3609: UPDATE oe_order_headers_all
3610: SET price_list_id=G_FIRST_LINE_PRICE_LIST_ID
3611: WHERE header_id=lx_header_id;
3612: EXCEPTION
3613: WHEN NO_DATA_FOUND THEN

Line 4061: , oe_order_headers_all retro_header

4057: , retro_header.order_type_id
4058: from
4059: oe_order_lines_all retro_line
4060: , oe_order_lines orig_line
4061: , oe_order_headers_all retro_header
4062: where orig_line.line_id = p_line_rec.reference_line_id
4063: and retro_line.order_source_id=27
4064: and retro_line.orig_sys_document_ref = to_char(orig_line.header_id) --bug5553346
4065: and retro_line.orig_sys_line_ref = to_char(p_line_rec.reference_line_id) --bug5553346

Line 4344: select header_id,booked_flag from oe_order_headers_all

4340: x_headers_processed OUT NOCOPY NUMBER
4341: )
4342: AS
4343: cursor retrobill_header(p_retrobill_request_id in VARCHAR2) is
4344: select header_id,booked_flag from oe_order_headers_all
4345: where orig_sys_document_ref=to_char(p_retrobill_request_id) --p_retrobill_request_id --commented for bug#7665009
4346: and order_source_id=27;
4347:
4348: l_header_count NUMBER;

Line 4445: select count(*) into l_header_count from oe_order_headers_all

4441: EXIT;
4442: END IF;--End of check purge_preview_orders
4443: END LOOP;
4444:
4445: select count(*) into l_header_count from oe_order_headers_all
4446: where orig_sys_document_ref=to_char(p_retrobill_request_id) -- p_retrobill_request_id --commented for bug#7665009
4447: and order_source_id=27;
4448:
4449: IF(l_header_count = 0) THEN