DBA Data[Home] [Help]

APPS.SHPBKLOG dependencies on DUAL

Line 105: from dual

101: /* determine if line is shippable */
102:
103: select nvl(min('Y'), 'N')
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

Line 117: from dual

113:
114:
115: select nvl(min('Y'), 'N')
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'

Line 127: from dual

123:
124:
125: select nvl(min('Y'), 'N')
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'