DBA Data[Home] [Help]

APPS.INV_MO_PURGE dependencies on OE_ORDER_LINES_ALL

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

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

Line 104: FROM oe_order_lines_all oola

100:
101: IF (can_delete = 1) THEN
102: SELECT 1
103: INTO can_delete
104: FROM oe_order_lines_all oola
105: WHERE oola.line_id = mo_line.txn_source_line_id
106: AND (oola.open_flag <> 'Y'
107: OR oola.cancelled_flag = 'Y'
108: )

Line 122: FROM oe_order_lines_all oola

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

Line 151: FROM oe_order_lines_all oola

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

Line 195: FROM oe_order_lines_all oola

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

Line 212: FROM oe_order_lines_all oola

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

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

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

Line 245: FROM oe_order_lines_all oola

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