APPS.OE_SO_ATO dependencies on SO_LINE_DETAILS

Line 47: FROM SO_LINE_DETAILS

43: INTO l_number_of_config_details,
44: l_reserved_quantity,
45: l_supply_reserved_quantity,
46: l_configured_quantity
47: FROM SO_LINE_DETAILS
48: WHERE LINE_ID = x_line_id
49: AND CONFIGURATION_ITEM_FLAG = 'Y';
50:
51:

Line 60: FROM SO_LINE_DETAILS

56: x_s27 := 4;
57:
58: SELECT DECODE(COUNT(1), 0, 0, 4)
59: INTO x_s27
60: FROM SO_LINE_DETAILS
61: WHERE LINE_ID = x_line_id
62: AND SCHEDULE_STATUS_CODE = 'DEMANDED';
63:
64: ELSIF l_reserved_quantity = 0 THEN

Line 101: FROM SO_LINE_DETAILS S

97: BEGIN
98:
99: SELECT INVENTORY_ITEM_ID, MIN(LINE_DETAIL_ID)
100: INTO x_configuration_item_id, x_config_line_detail_id
101: FROM SO_LINE_DETAILS S
102: WHERE S.LINE_ID = x_line_id
103: AND CONFIGURATION_ITEM_FLAG = 'Y'
104: GROUP BY INVENTORY_ITEM_ID;
105:

Line 134: from so_line_details

130:
131: BEGIN
132: SELECT sum(wip_completed_quantity)
133: into x_reserved_quantity
134: from so_line_details
135: where line_id = x_line_id
136: and inventory_item_id = x_configuration_item_id;
137: EXCEPTION
138: When NO_DATA_FOUND then