APPS.INV_MO_PURGE dependencies on OE_ORDER_LINES_ALL

Line 85: order_line is not open (OE_ORDER_LINES_ALL.OPEN_FLAG <> 'Y')

81: -- Pick Wave Move Order
82: IF mo_line.mo_type = 3 THEN
83: IF mo_line.line_status IN (5, 6) THEN
84: /* Delete MTRL if inventory interface has completed successfully and
85: order_line is not open (OE_ORDER_LINES_ALL.OPEN_FLAG <> 'Y')
86: or is cancelled (CANCELLED_FLAG = 'Y')*/
87: wdd_exists := 'Y'; -- Added for bug # 6469970
88: oel_exists := 'Y'; -- Added for bug # 6469970
89: BEGIN

Line 100: FROM oe_order_lines_all oola

96:
97: IF (can_delete = 1) THEN
98: SELECT 1
99: INTO can_delete
100: FROM oe_order_lines_all oola
101: WHERE oola.line_id = mo_line.txn_source_line_id
102: AND (oola.open_flag <> 'Y'
103: OR oola.cancelled_flag = 'Y'
104: )

Line 118: FROM oe_order_lines_all oola

114: IF (can_delete = 0) THEN
115: BEGIN
116: SELECT 1
117: INTO can_delete
118: FROM oe_order_lines_all oola
119: WHERE oola.line_id = mo_line.txn_source_line_id
120: AND ( (NVL(open_flag, 'Y') = 'N') OR cancelled_flag = 'Y')
121: AND NOT EXISTS (
122: SELECT 1

Line 147: FROM oe_order_lines_all oola

143: (mo_line.quantity > 0 AND mo_line.quantity_delivered = 0))) THEN
144: BEGIN
145: SELECT 1
146: INTO can_delete
147: FROM oe_order_lines_all oola
148: WHERE oola.line_id = mo_line.txn_source_line_id
149: AND (NVL(open_flag,'Y') ='Y' and cancelled_flag='N')
150: AND NOT EXISTS (
151: SELECT 1

Line 191: FROM oe_order_lines_all oola

187: IF (can_delete = 1 and wdd_exists = 'N') THEN
188: BEGIN
189: SELECT 0
190: INTO can_delete
191: FROM oe_order_lines_all oola
192: WHERE oola.line_id = mo_line.txn_source_line_id
193: AND (oola.open_flag = 'Y' AND NVL(oola.CANCELLED_FLAG,'N')='N');
194: -- If row found; can't delete
195: can_delete := 0;

Line 208: FROM oe_order_lines_all oola

204: IF (can_delete = 0) THEN
205: BEGIN
206: SELECT 'Y'
207: INTO oel_exists
208: FROM oe_order_lines_all oola
209: WHERE oola.line_id = mo_line.txn_source_line_id
210: and rownum < 2;
211:
212: IF oel_exists = 'Y' THEN

Line 227: and order_line is not open (OE_ORDER_LINES_ALL.OPEN_FLAG <> 'Y') */

223:
224: ELSE -- line status is 9
225: /* Delete MTRL if allocations doesn't exist
226: (MMTT should not exist for this line id, MMTT.move_order_line_id = MTRL.line_id)
227: and order_line is not open (OE_ORDER_LINES_ALL.OPEN_FLAG <> 'Y') */
228: BEGIN
229: SELECT 1
230: INTO can_delete
231: FROM mtl_material_transactions_temp mmtt

Line 241: FROM oe_order_lines_all oola

237: WHEN NO_DATA_FOUND THEN
238: BEGIN
239: SELECT 1
240: INTO can_delete
241: FROM oe_order_lines_all oola
242: WHERE oola.line_id = mo_line.txn_source_line_id
243: AND (oola.open_flag <> 'Y'
244: OR oola.cancelled_flag = 'Y'
245: )