APPS.OEXBMCBK dependencies on SO_LINE_DETAILS

Line 75: FROM SO_LINE_DETAILS

71: OR ATO_LINE_ID = dem_src_line)
72: AND ATO_FLAG = 'Y'
73: AND NOT EXISTS
74: (SELECT 'Released Details'
75: FROM SO_LINE_DETAILS
76: WHERE LINE_ID IN
77: (SELECT LINE_ID
78: FROM SO_LINES_ALL
79: WHERE LINE_ID = dem_src_line)

Line 105: INSERT INTO SO_LINE_DETAILS

101: -- information as the link_model line detail when linking configuration item
102:
103: stmt_number := 5;
104:
105: INSERT INTO SO_LINE_DETAILS
106: (LINE_ID,
107: LINE_DETAIL_ID,
108: DELIVERY,
109: CREATED_BY,

Line 157: SO_LINE_DETAILS_S.NEXTVAL,

153: ATTRIBUTE13,
154: ATTRIBUTE14,
155: ATTRIBUTE15)
156: SELECT LD.LINE_ID,
157: SO_LINE_DETAILS_S.NEXTVAL,
158: dem_src_delivery,
159: user_id,
160: SYSDATE,
161: user_id,

Line 207: FROM SO_LINE_DETAILS LD

203: LD.ATTRIBUTE12,
204: LD.ATTRIBUTE13,
205: LD.ATTRIBUTE14,
206: LD.ATTRIBUTE15
207: FROM SO_LINE_DETAILS LD
208: WHERE LD.LINE_ID = dem_src_line
209: AND LD.INCLUDED_ITEM_FLAG = 'N'
210: AND ROWNUM = 1;
211:

Line 214: -- Delete the configuration item detail from so_line_details when the

210: AND ROWNUM = 1;
211:
212: ELSIF (link_mode = 2) THEN
213:
214: -- Delete the configuration item detail from so_line_details when the
215: -- configuration item is delinked in mtl_demand
216:
217: stmt_number := 6;
218:

Line 219: DELETE FROM SO_LINE_DETAILS

215: -- configuration item is delinked in mtl_demand
216:
217: stmt_number := 6;
218:
219: DELETE FROM SO_LINE_DETAILS
220: WHERE LINE_ID = dem_src_line
221: AND INVENTORY_ITEM_ID = config_item_id;
222:
223: END IF;