APPS.OE_RETROBILL_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 233: OE_ORDER_HEADERS_ALL h

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

Line 525: FROM oe_order_headers_all

521: EXCEPTION
522: WHEN NO_DATA_FOUND THEN
523: BEGIN
524: SELECT order_number INTO l_order_number
525: FROM oe_order_headers_all
526: WHERE header_id=p_header_id;
527:
528: l_line_no := OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(p_line_id);
529: EXCEPTION

Line 3125: FROM oe_order_headers_all

3121:
3122: BEGIN
3123:
3124: SELECT price_list_id INTO l_header_price_list_id
3125: FROM oe_order_headers_all
3126: WHERE header_id=lx_header_id;
3127:
3128: IF ((G_FIRST_LINE_DELETED='Y' AND
3129: G_FIRST_LINE_PL_ASSIGNED='Y' AND

Line 3133: UPDATE oe_order_headers_all

3129: G_FIRST_LINE_PL_ASSIGNED='Y' AND
3130: G_FIRST_LINE_PRICE_LIST_ID IS NOT NULL) OR
3131: (l_header_price_list_id IS NULL)) THEN
3132: BEGIN
3133: UPDATE oe_order_headers_all
3134: SET price_list_id=G_FIRST_LINE_PRICE_LIST_ID
3135: WHERE header_id=lx_header_id;
3136: EXCEPTION
3137: WHEN NO_DATA_FOUND THEN

Line 3216: FROM oe_order_headers_all

3212: End If;
3213: BEGIN
3214:
3215: SELECT price_list_id INTO l_header_price_list_id
3216: FROM oe_order_headers_all
3217: WHERE header_id=lx_header_id;
3218:
3219: IF ((G_FIRST_LINE_DELETED='Y' AND
3220: G_FIRST_LINE_PL_ASSIGNED='Y' AND

Line 3224: UPDATE oe_order_headers_all

3220: G_FIRST_LINE_PL_ASSIGNED='Y' AND
3221: G_FIRST_LINE_PRICE_LIST_ID IS NOT NULL) OR
3222: (l_header_price_list_id IS NULL)) THEN
3223: BEGIN
3224: UPDATE oe_order_headers_all
3225: SET price_list_id=G_FIRST_LINE_PRICE_LIST_ID
3226: WHERE header_id=lx_header_id;
3227: EXCEPTION
3228: WHEN NO_DATA_FOUND THEN

Line 3660: , oe_order_headers_all retro_header

3656: , retro_header.order_type_id
3657: from
3658: oe_order_lines_all retro_line
3659: , oe_order_lines orig_line
3660: , oe_order_headers_all retro_header
3661: where orig_line.line_id = p_line_rec.reference_line_id
3662: and retro_line.order_source_id=27
3663: and retro_line.orig_sys_document_ref = to_char(orig_line.header_id) --bug5553346
3664: and retro_line.orig_sys_line_ref = to_char(p_line_rec.reference_line_id) --bug5553346

Line 3919: select header_id,booked_flag from oe_order_headers_all

3915: x_headers_processed OUT NOCOPY NUMBER
3916: )
3917: AS
3918: cursor retrobill_header(p_retrobill_request_id in VARCHAR2) is
3919: select header_id,booked_flag from oe_order_headers_all
3920: where orig_sys_document_ref=p_retrobill_request_id
3921: and order_source_id=27;
3922:
3923: l_header_count NUMBER;

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

4016: EXIT;
4017: END IF;--End of check purge_preview_orders
4018: END LOOP;
4019:
4020: select count(*) into l_header_count from oe_order_headers_all
4021: where orig_sys_document_ref=p_retrobill_request_id
4022: and order_source_id=27;
4023:
4024: IF(l_header_count = 0) THEN