APPS.INV_CONSIGNED_DIAGNOSTICS_PROC dependencies on MTL_CONSIGNED_DIAG_ERRORS

Line 104: UPDATE mtl_consigned_diag_errors mcde

100: INV_LOG_UTIL.trace
101: ( '>> Update_Consumption_Date',null,9);
102: END IF;
103:
104: UPDATE mtl_consigned_diag_errors mcde
105: SET mcde.consumption_date =
106: ( select MIN(mmt.transaction_date)
107: FROM mtl_material_transactions mmt
108: WHERE mmt.inventory_item_id = mcde.inventory_item_id

Line 158: mtl_consigned_diag_errors

154: ( '>> Purge_diagnostics_passed_rec' ,9);
155: END IF;
156:
157: DELETE FROM
158: mtl_consigned_diag_errors
159: WHERE ( request_id <> g_request_id) OR (
160: request_id is NULL ) ;
161:
162:

Line 209: mtl_consigned_diag_errors

205: BEGIN
206: IF p_record_type = 1
207: THEN
208: INSERT INTO
209: mtl_consigned_diag_errors
210: ( RECORD_ID
211: , ORGANIZATION_ID
212: , INVENTORY_ITEM_ID
213: , REVISION

Line 238: mtl_consigned_diag_errors_s.NEXTVAL

234: , error_type
235: , primary_uom
236: , purchasing_uom
237: ) SELECT
238: mtl_consigned_diag_errors_s.NEXTVAL
239: , mcdet.ORGANIZATION_ID
240: , mcdet.INVENTORY_ITEM_ID
241: , mcdet.REVISION
242: , 1

Line 269: FROM mtl_consigned_diag_errors mcde

265: FROM mtl_consigned_diag_temp mcdet
266: WHERE mcdet.error_code is not null
267: AND NOT EXISTS
268: ( SELECT 1
269: FROM mtl_consigned_diag_errors mcde
270: WHERE mcde.organization_id =
271: mcdet.organization_id
272: and mcde.owning_organization_id =
273: mcdet.owning_organization_id

Line 287: UPDATE mtl_consigned_diag_errors mcde

283: INV_LOG_UTIL.trace
284: ( 'Phase 2',9);
285: END IF;
286:
287: UPDATE mtl_consigned_diag_errors mcde
288: SET mcde.request_id =
289: ( SELECT g_request_id
290: FROM mtl_consigned_diag_temp mcdet
291: WHERE MCDE.organization_id = mcdet.organization_id

Line 306: mtl_consigned_diag_errors

302:
303:
304: ELSE
305: INSERT INTO
306: mtl_consigned_diag_errors
307: ( RECORD_ID
308: , ORGANIZATION_ID
309: , INVENTORY_ITEM_ID
310: , REVISION

Line 335: mtl_consigned_diag_errors_s.NEXTVAL

331: , error_type
332: , primary_uom
333: , purchasing_uom
334: ) SELECT
335: mtl_consigned_diag_errors_s.NEXTVAL
336: , mcdet.ORGANIZATION_ID
337: , mcdet.INVENTORY_ITEM_ID
338: , mcdet.REVISION
339: , 1

Line 366: FROM mtl_consigned_diag_errors mcde

362: FROM mtl_consigned_diag_temp mcdet
363: WHERE mcdet.error_code is not null
364: AND NOT EXISTS
365: ( SELECT 1
366: FROM mtl_consigned_diag_errors mcde
367: WHERE mcde.organization_id =
368: mcdet.organization_id
369: and mcde.owning_organization_id =
370: mcdet.owning_organization_id

Line 387: UPDATE mtl_consigned_diag_errors mcde

383: ( 'Phase 2 ',9);
384: END IF;
385:
386:
387: UPDATE mtl_consigned_diag_errors mcde
388: SET mcde.request_id =
389: ( SELECT g_request_id
390: FROM mtl_consigned_diag_temp mcdet
391: WHERE MCDE.organization_id = mcdet.organization_id

Line 856: MTL_CONSIGNED_DIAG_ERRORS

852: , organization_id
853: , owning_organization_id
854: , 2
855: FROM
856: MTL_CONSIGNED_DIAG_ERRORS
857: WHERE record_id = p_error_record_id ;
858:
859: END IF;
860:

Line 1131: MTL_consigned_diag_errors

1127: , REVISION
1128: , OWNING_ORGANIZATION_ID
1129: , 1
1130: FROM
1131: MTL_consigned_diag_errors
1132: WHERE record_id = p_error_record_id ;
1133:
1134: END IF;
1135:

Line 1426: mtl_consigned_diag_errors

1422: l_record_type
1423: , l_request_id
1424: , l_error_code
1425: FROM
1426: mtl_consigned_diag_errors
1427: WHERE record_id = p_error_record_id ;
1428:
1429: EXCEPTION
1430: WHEN NO_DATA_FOUND

Line 1480: DELETE from mtl_consigned_diag_errors

1476: BEGIN
1477: IF g_revalidate_error_code IS NULL
1478: THEN
1479: x_result_out := 'PASS' ;
1480: DELETE from mtl_consigned_diag_errors
1481: WHERE record_id = p_error_record_id ;
1482: ELSE
1483: x_result_out := 'FAIL' ;
1484: IF g_revalidate_error_code <> l_error_code

Line 1486: DELETE from mtl_consigned_diag_errors

1482: ELSE
1483: x_result_out := 'FAIL' ;
1484: IF g_revalidate_error_code <> l_error_code
1485: THEN
1486: DELETE from mtl_consigned_diag_errors
1487: WHERE record_id = p_error_record_id ;
1488:
1489: END IF;
1490: INV_CONSIGNED_DIAGNOSTICS_PROC.Update_Consumption_Date ;