APPS.OE_OPT_PROCESS dependencies on SO_LINES

Line 45: ,SO_LINES OELIN

41: x_options_comp_code, NULL, OELIN.LINE_ID )
42: ,BOMEXP.COMPONENT_CODE
43: FROM BOM_EXPLOSIONS BOMEXP
44: ,MTL_SYSTEM_ITEMS MTLITM
45: ,SO_LINES OELIN
46: WHERE BOMEXP.TOP_BILL_SEQUENCE_ID = x_lines_comp_seq_id
47: AND BOMEXP.EXPLOSION_TYPE = 'OPTIONAL'
48: AND BOMEXP.PLAN_LEVEL <= x_options_plan_level
49: AND BOMEXP.EFFECTIVITY_DATE <=

Line 106: --cannot search SO_LINES for a parent ATO component because it may not yet

102: lookup_code = Options_Item_Type_Code;
103:
104:
105: --Search for a parent ATO component in the explosion table. Note that we
106: --cannot search SO_LINES for a parent ATO component because it may not yet
107: --exist in the database. Also note that we're looking for the highest-
108: --positioned ATO component in the BOM (the ORDER BY clause ensures that the
109: --highest-positioned component is selected first). The cursor now
110: --explicitly retrieves only the first record.

Line 224: FROM SO_LINES

220: begin
221:
222: SELECT COMPONENT_CODE
223: INTO Options_ATO_Parent_Comp_Code
224: FROM SO_LINES
225: WHERE LINE_ID = Options_ATO_Line_Id;
226:
227: exception
228:

Line 407: FROM SO_LINES

403:
404: begin
405:
406: SELECT NULL INTO L_Dummy
407: FROM SO_LINES
408: WHERE ROWID = P_Row_Id
409: AND NVL( ORDERED_QUANTITY, -1 )
410: <> NVL( P_Ordered_Quantity, -1 );
411: