APPS.OE_INF_POPULATE_PUB dependencies on OE_ORDER_LINES

Line 1151: from oe_order_lines_all

1147: , shipped_quantity2 /* number */
1148: , cancelled_quantity2 /* number */
1149: , fulfilled_quantity2 /* number */
1150:
1151: from oe_order_lines_all
1152: where header_id = old_header_id_v;
1153:
1154: IF SQL%ROWCOUNT > 0 THEN
1155: IF l_debug_level > 0 THEN

Line 2001: where line_id in (select line_id from oe_order_lines

1997: , ORDER_SOURCE_ID_V /*ORDER_SOURCE_ID NULL*/
1998: , to_char(ORDER_NUMBER_V) /*ORIG_SYS_DOCUMENT_RE NULL*/
1999: , l_sold_to_org_id /*L_SOLD_TO_ORG_ID NULL*/
2000: From oe_lot_serial_numbers
2001: where line_id in (select line_id from oe_order_lines
2002: where header_id = old_header_id_v);
2003:
2004: IF SQL%ROWCOUNT > 0 THEN
2005: IF l_debug_level > 0 THEN

Line 2055: FROM oe_order_lines

2051:
2052: -- dbms_output.put_line('line id =>' || to_char(p_line_id));
2053: SELECT link_to_line_id, line_number, option_number
2054: INTO l_link_to_line_id, l_line_number,l_option_number
2055: FROM oe_order_lines
2056: WHERE line_id = p_line_id;
2057:
2058: IF l_debug_level > 0 THEN
2059: oe_debug_pub.add( 'OEXPIFPB: AFTER SELECTING LINK DATA' ) ;

Line 2075: FROM oe_order_lines

2071: END IF;
2072: BEGIN
2073: SELECT line_number, option_number
2074: INTO l_line_number, l_option_number
2075: FROM oe_order_lines
2076: WHERE line_id = l_link_to_line_id;
2077: END;
2078:
2079: -- dbms_output.put_line('link to line id is not null');

Line 2117: FROM oe_order_lines

2113: END IF;
2114:
2115: SELECT top_model_line_id, line_number, option_number
2116: INTO l_top_model_line_id, l_line_number,l_option_number
2117: FROM oe_order_lines
2118: WHERE line_id = p_line_id;
2119:
2120: IF l_top_model_line_id is null THEN
2121: -- dbms_output.put_line('top model is null');

Line 2134: FROM oe_order_lines

2130: END IF;
2131: BEGIN
2132: SELECT line_number, option_number
2133: INTO l_line_number, l_option_number
2134: FROM oe_order_lines
2135: WHERE line_id = l_top_model_line_id;
2136: END;
2137:
2138: -- dbms_output.put_line('top model is not null before retunr');