APPS.SHPBKLOG dependencies on SO_LINE_DETAILS

Line 108: from so_line_details

104: into SHIPPABLE
105: from dual
106: where exists
107: (select 'shippable detail'
108: from so_line_details
109: where line_id = O_LINE_ID
110: and shippable_flag = 'Y');
111:
112: /* determine if anything was released */

Line 120: from so_line_details

116: into SOMETHING_RELEASED
117: from dual
118: where exists
119: (select 'released details'
120: from so_line_details
121: where nvl(released_flag, 'N') = 'Y'
122: and line_id = O_LINE_ID);
123:
124:

Line 130: from so_line_details

126: into ALL_DETAILS_RELEASED
127: from dual
128: where not exists
129: (select 'unreleased detail'
130: from so_line_details
131: where nvl(released_flag, 'N') = 'N'
132: and line_id = O_LINE_ID);
133:
134:

Line 158: from so_line_details ld

154: IF (SHIPPABLE = 'Y' and SOMETHING_RELEASED = 'Y')
155: then
156: select nvl(min('Y'), 'N')
157: into ALL_SHIPPABLE_RELEASED
158: from so_line_details ld
159: where ld.line_id = O_LINE_ID
160: and ld.shippable_flag = 'Y'
161: and ld.inventory_item_id+0 in
162: (select distinct spl.inventory_item_id+0

Line 237: from so_line_details ld

233: pl.picking_header_id = ph.picking_header_id and
234: ph.status_code in ('CLOSED', 'PENDING', 'OPEN') and
235: exists
236: (select 'child is shippable'
237: from so_line_details ld
238: where ld.line_id = child.line_id) and
239: not exists
240: (SELECT 'UNREPRESENTED COMPONENT'
241: FROM SO_LINE_DETAILS LD

Line 241: FROM SO_LINE_DETAILS LD

237: from so_line_details ld
238: where ld.line_id = child.line_id) and
239: not exists
240: (SELECT 'UNREPRESENTED COMPONENT'
241: FROM SO_LINE_DETAILS LD
242: WHERE LD.LINE_ID = child.LINE_ID
243: AND LD.SHIPPABLE_FLAG = 'Y'
244: AND LD.INVENTORY_ITEM_ID+0 NOT IN
245: (SELECT DISTINCT SPL.INVENTORY_ITEM_ID+0