eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CONSIGNED_DIAGNOSTICS_PROC dependencies on MTL_CONSIGNED_DIAG_TEMP

Line 265: FROM mtl_consigned_diag_temp mcdet

261: , sysdate
262: , error_type
263: , primary_uom
264: , purchasing_uom
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

Line 290: FROM mtl_consigned_diag_temp mcdet

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
292: AND MCDE.owning_organization_id =
293: mcdet.owning_organization_id
294: AND MCDE.error_code = mcdet.mcde_error_code

Line 362: FROM mtl_consigned_diag_temp mcdet

358: , sysdate
359: , error_type
360: , primary_uom
361: , purchasing_uom
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

Line 390: FROM mtl_consigned_diag_temp mcdet

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
392: AND MCDE.owning_organization_id =
393: mcdet.owning_organization_id
394: AND MCDE.error_code = mcdet.mcde_error_code

Line 773: FROM mtl_consigned_diag_temp ;

769: , INVENTORY_ITEM_ID
770: , REVISION
771: , OWNING_ORGANIZATION_ID
772: , po_header_id
773: FROM mtl_consigned_diag_temp ;
774:
775: l_cad_temp_rec C_cad_temp%ROWTYPE ;
776:
777:

Line 800: DELETE FROM mtl_consigned_diag_temp ;

796: ( 'p_error_record_id => '|| p_error_record_id ,
797: 'Consumption_Advice_diagnostics ',9);
798: END IF;
799:
800: DELETE FROM mtl_consigned_diag_temp ;
801:
802: IF p_error_record_id IS NULL
803: THEN
804: IF g_debug = 1

Line 807: ( 'REGULAR - Before Insert into mtl_consigned_diag_temp' ,

803: THEN
804: IF g_debug = 1
805: THEN
806: INV_LOG_UTIL.trace
807: ( 'REGULAR - Before Insert into mtl_consigned_diag_temp' ,
808: 'Consumption_Advice_diagnostics',9);
809: END IF;
810:
811: INSERT into mtl_consigned_diag_temp (

Line 811: INSERT into mtl_consigned_diag_temp (

807: ( 'REGULAR - Before Insert into mtl_consigned_diag_temp' ,
808: 'Consumption_Advice_diagnostics',9);
809: END IF;
810:
811: INSERT into mtl_consigned_diag_temp (
812: PO_header_id
813: , INVENTORY_ITEM_ID
814: , REVISION
815: , organization_id

Line 837: ( 'REVALIDATE - Before Insert into mtl_consigned_diag_temp' ,

833: ELSE
834: IF g_debug = 1
835: THEN
836: INV_LOG_UTIL.trace
837: ( 'REVALIDATE - Before Insert into mtl_consigned_diag_temp' ,
838: 'Consumption_Advice_diagnostics',9);
839: END IF;
840:
841: INSERT into mtl_consigned_diag_temp (

Line 841: INSERT into mtl_consigned_diag_temp (

837: ( 'REVALIDATE - Before Insert into mtl_consigned_diag_temp' ,
838: 'Consumption_Advice_diagnostics',9);
839: END IF;
840:
841: INSERT into mtl_consigned_diag_temp (
842: PO_header_id
843: , INVENTORY_ITEM_ID
844: , REVISION
845: , organization_id

Line 864: ( 'after Insert into mtl_consigned_diag_temp' ,

860:
861: IF g_debug = 1
862: THEN
863: INV_LOG_UTIL.trace
864: ( 'after Insert into mtl_consigned_diag_temp' ,
865: 'Consumption_Advice_diagnostics',9);
866: END IF;
867:
868:

Line 943: UPDATE mtl_consigned_diag_temp

939: , x_error_type => l_error_type
940: );
941:
942:
943: UPDATE mtl_consigned_diag_temp
944: SET error_code = l_error_code
945: , mcde_error_code = l_cad_error_code
946: , mcde_action_code = l_cad_action_code
947: , agent_id = l_buyer_id

Line 966: ( 'after UPDATE mtl_consigned_diag_temp '

962:
963: IF (g_debug = 1)
964: THEN
965: INV_LOG_UTIL.trace
966: ( 'after UPDATE mtl_consigned_diag_temp '
967: ,'Consumption_Advice_diagnostics'
968: , 9
969: );
970: END IF;

Line 1040: FROM mtl_consigned_diag_temp ;

1036: ORGANIZATION_ID
1037: , INVENTORY_ITEM_ID
1038: , REVISION
1039: , OWNING_ORGANIZATION_ID
1040: FROM mtl_consigned_diag_temp ;
1041:
1042: l_moqd_temp_rec C_moqd_temp%ROWTYPE ;
1043:
1044:

Line 1084: DELETE FROM mtl_consigned_diag_temp ;

1080: 'Ownership_transfer_diagnostics' ,9);
1081: END IF;
1082:
1083:
1084: DELETE FROM mtl_consigned_diag_temp ;
1085:
1086: IF p_error_record_id is NULL
1087: THEN
1088: IF g_debug = 1

Line 1095: INSERT INTO mtl_consigned_diag_temp (

1091: ( ' REgular - Before Insert into Temp ',
1092: 'Ownership_transfer_diagnostics' ,9);
1093: END IF;
1094:
1095: INSERT INTO mtl_consigned_diag_temp (
1096: ORGANIZATION_ID
1097: , INVENTORY_ITEM_ID
1098: , REVISION
1099: , OWNING_ORGANIZATION_ID

Line 1118: INSERT INTO mtl_consigned_diag_temp (

1114: ( ' REvalidate - Before Insert into Temp ',
1115: 'Ownership_transfer_diagnostics' ,9);
1116: END IF;
1117:
1118: INSERT INTO mtl_consigned_diag_temp (
1119: ORGANIZATION_ID
1120: , INVENTORY_ITEM_ID
1121: , REVISION
1122: , OWNING_ORGANIZATION_ID

Line 1288: UPDATE mtl_consigned_diag_temp

1284: , x_error_type => l_error_type
1285: );
1286:
1287:
1288: UPDATE mtl_consigned_diag_temp
1289: SET error_code = l_error_code
1290: , mcde_error_code = l_mcde_error_code
1291: , mcde_action_code = l_mcde_action_code
1292: , agent_id = l_buyer_id

Line 1318: ( 'after UPDATE mtl_consigned_diag_temp '

1314:
1315: IF (g_debug = 1)
1316: THEN
1317: INV_LOG_UTIL.trace
1318: ( 'after UPDATE mtl_consigned_diag_temp '
1319: ,'Ownership_transfer_diagnostics'
1320: , 9
1321: );
1322: END IF;