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.INVPVDR2 dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 267: from MTL_SYSTEM_ITEMS_INTERFACE

263: INTERNAL_VOLUME,
264: MAXIMUM_LOAD_WEIGHT,
265: MINIMUM_FILL_PERCENT,
266: VEHICLE_ITEM_FLAG
267: from MTL_SYSTEM_ITEMS_INTERFACE
268: where ((organization_id = org_id) or
269: (all_Org = 1))
270: and set_process_id = xset_id
271: and process_flag in ( 31,41);

Line 323: 'MTL_SYSTEM_ITEMS_INTERFACE',

319: request_id,
320: cr.TRANSACTION_ID,
321: 'Validation Error : Fixed Order Qty is <= 0 - Use a Value > 0 or Null',
322: 'FIXED_ORDER_QUANTITY',
323: 'MTL_SYSTEM_ITEMS_INTERFACE',
324: 'INV_IOI_FIXED_ORDER_QTY',
325: err_text);
326: if dumm_status < 0 then
327: raise LOGGING_ERR;

Line 344: 'MTL_SYSTEM_ITEMS_INTERFACE',

340: request_id,
341: cr.TRANSACTION_ID,
342: 'Validation Error : Fixed Days Supply is < 0 - Use a Value >= 0 or Null',
343: 'FIXED_DAYS_SUPPLY',
344: 'MTL_SYSTEM_ITEMS_INTERFACE',
345: 'INV_IOI_FIXED_SUP_DAYS',
346: err_text);
347: if dumm_status < 0 then
348: raise LOGGING_ERR;

Line 386: 'MTL_SYSTEM_ITEMS_INTERFACE',

382: request_id,
383: cr.TRANSACTION_ID,
384: l_msg_text,
385: 'ENCUMBRANCE_ACCOUNT',
386: 'MTL_SYSTEM_ITEMS_INTERFACE',
387: 'INV_IOI_ERR',
388: err_text);
389: if dumm_status < 0 then
390: raise LOGGING_ERR;

Line 409: 'MTL_SYSTEM_ITEMS_INTERFACE',

405: request_id,
406: cr.TRANSACTION_ID,
407: error_msg,
408: 'SERVICE_DURATION',
409: 'MTL_SYSTEM_ITEMS_INTERFACE',
410: 'INV_SER_DURATION_MAND',
411: err_text);
412: if dumm_status < 0 then
413: raise LOGGING_ERR;

Line 430: 'MTL_SYSTEM_ITEMS_INTERFACE',

426: request_id,
427: cr.TRANSACTION_ID,
428: error_msg,
429: 'WARRANTY_VENDOR_ID',
430: 'MTL_SYSTEM_ITEMS_INTERFACE',
431: 'INV_WARRANTY_VEND_ID',
432: err_text);
433: if dumm_status < 0 then
434: raise LOGGING_ERR;

Line 453: 'MTL_SYSTEM_ITEMS_INTERFACE',

449: request_id,
450: cr.TRANSACTION_ID,
451: error_msg,
452: 'INSPECTION_REQUIRED_FLAG',
453: 'MTL_SYSTEM_ITEMS_INTERFACE',
454: 'INV_INSPECTION_FLAG_ERR',
455: err_text);
456: if dumm_status < 0 then
457: raise LOGGING_ERR;

Line 475: 'MTL_SYSTEM_ITEMS_INTERFACE',

471: request_id,
472: cr.TRANSACTION_ID,
473: error_msg,
474: 'RESPONSE_TIME_VALUE',
475: 'MTL_SYSTEM_ITEMS_INTERFACE',
476: 'INV_IOI_RESP_TIME_VAL',
477: err_text);
478: if dumm_status < 0 then
479: raise LOGGING_ERR;

Line 497: 'MTL_SYSTEM_ITEMS_INTERFACE',

493: request_id,
494: cr.TRANSACTION_ID,
495: error_msg,
496: 'DEMAND_TIME_FENCE_DAYS',
497: 'MTL_SYSTEM_ITEMS_INTERFACE',
498: 'INV_DEMAND_DAYS',
499: err_text);
500: if dumm_status < 0 then
501: raise LOGGING_ERR;

Line 521: 'MTL_SYSTEM_ITEMS_INTERFACE',

517: request_id,
518: cr.TRANSACTION_ID,
519: error_msg,
520: 'DEMAND_TIME_FENCE_DAYS',
521: 'MTL_SYSTEM_ITEMS_INTERFACE',
522: 'INV_IOI_DEMAND_TM_FENCE_DAYS',
523: err_text);
524: if dumm_status < 0 then
525: raise LOGGING_ERR;

Line 543: 'MTL_SYSTEM_ITEMS_INTERFACE',

539: request_id,
540: cr.TRANSACTION_ID,
541: error_msg,
542: 'PLANNING_TIME_FENCE_DAYS',
543: 'MTL_SYSTEM_ITEMS_INTERFACE',
544: 'INV_PLANNING_DAYS',
545: err_text);
546: if dumm_status < 0 then
547: raise LOGGING_ERR;

Line 565: 'MTL_SYSTEM_ITEMS_INTERFACE',

561: request_id,
562: cr.TRANSACTION_ID,
563: error_msg,
564: 'PLANNING_TIME_FENCE_DAYS',
565: 'MTL_SYSTEM_ITEMS_INTERFACE',
566: 'INV_IOI_PLANNING_TM_FENCE_DAYS',
567: err_text);
568: if dumm_status < 0 then
569: raise LOGGING_ERR;

Line 587: 'MTL_SYSTEM_ITEMS_INTERFACE',

583: request_id,
584: cr.TRANSACTION_ID,
585: error_msg,
586: 'location_control_code',
587: 'MTL_SYSTEM_ITEMS_INTERFACE',
588: 'INV_DYNAMIC_LOCATORS',
589: err_text);
590: if dumm_status < 0 then
591: raise LOGGING_ERR;

Line 613: 'MTL_SYSTEM_ITEMS_INTERFACE',

609: request_id,
610: cr.TRANSACTION_ID,
611: error_msg,
612: 'RESTRICT_LOCATORS_CODE',
613: 'MTL_SYSTEM_ITEMS_INTERFACE',
614: 'INV_LOC_NOT_RESTRICT',
615: err_text);
616: if dumm_status < 0 then
617: raise LOGGING_ERR;

Line 633: 'MTL_SYSTEM_ITEMS_INTERFACE',

629: request_id,
630: cr.TRANSACTION_ID,
631: error_msg,
632: 'RESTRICT_LOCATORS_CODE',
633: 'MTL_SYSTEM_ITEMS_INTERFACE',
634: 'INV_DYNAMIC_LOCATORS',
635: err_text);
636: if dumm_status < 0 then
637: raise LOGGING_ERR;

Line 657: 'MTL_SYSTEM_ITEMS_INTERFACE',

653: request_id,
654: cr.TRANSACTION_ID,
655: error_msg,
656: 'EXPENSE_ACCOUNT',
657: 'MTL_SYSTEM_ITEMS_INTERFACE',
658: 'INV_EXP_ACCT_REQ', -- fix for BUG 3069139
659: err_text);
660: if dumm_status < 0 then
661: raise LOGGING_ERR;

Line 681: 'MTL_SYSTEM_ITEMS_INTERFACE',

677: request_id,
678: cr.TRANSACTION_ID,
679: error_msg,
680: 'INVENTORY_ASSET_FLAG',
681: 'MTL_SYSTEM_ITEMS_INTERFACE',
682: 'INV_COST_ASSET',
683: err_text);
684: if dumm_status < 0 then
685: raise LOGGING_ERR;

Line 704: 'MTL_SYSTEM_ITEMS_INTERFACE',

700: request_id,
701: cr.TRANSACTION_ID,
702: error_msg,
703: 'POSTPROCESSING_LEADTIME',
704: 'MTL_SYSTEM_ITEMS_INTERFACE',
705: 'INV_IOI_POST_PROC_LEAD_TIME',
706: err_text);
707: if dumm_status < 0 then
708: raise LOGGING_ERR;

Line 727: 'MTL_SYSTEM_ITEMS_INTERFACE',

723: request_id,
724: cr.TRANSACTION_ID,
725: error_msg,
726: 'LEAD_TIME_LOT_SIZE',
727: 'MTL_SYSTEM_ITEMS_INTERFACE',
728: 'INV_IOI_LEAD_TIME_LOT_SIZE',
729: err_text);
730: if dumm_status < 0 then
731: raise LOGGING_ERR;

Line 753: 'MTL_SYSTEM_ITEMS_INTERFACE',

749: request_id,
750: cr.TRANSACTION_ID,
751: error_msg,
752: 'ATP_COMPONENTS_FLAG1',
753: 'MTL_SYSTEM_ITEMS_INTERFACE',
754: 'INV_IOI_ATP_COMPS',
755: err_text);
756: if dumm_status < 0 then
757: raise LOGGING_ERR;

Line 783: 'MTL_SYSTEM_ITEMS_INTERFACE',

779: request_id,
780: cr.TRANSACTION_ID,
781: error_msg,
782: 'ATP_COMPONENTS_FLAG1',
783: 'MTL_SYSTEM_ITEMS_INTERFACE',
784: 'INV_ATP_COMPS',
785: err_text);
786: if dumm_status < 0 then
787: raise LOGGING_ERR;

Line 806: 'MTL_SYSTEM_ITEMS_INTERFACE',

802: request_id,
803: cr.TRANSACTION_ID,
804: error_msg,
805: 'REPETITIVE_PLANNING_FLAG',
806: 'MTL_SYSTEM_ITEMS_INTERFACE',
807: 'INV_REPETITIVE_MAND',
808: err_text);
809: if dumm_status < 0 then
810: raise LOGGING_ERR;

Line 828: 'MTL_SYSTEM_ITEMS_INTERFACE',

824: request_id,
825: cr.TRANSACTION_ID,
826: error_msg,
827: 'MTL_TRANSACTIONS_ENABLED_FLAG',
828: 'MTL_SYSTEM_ITEMS_INTERFACE',
829: 'INV_TRX',
830: err_text);
831: if dumm_status < 0 then
832: raise LOGGING_ERR;

Line 850: 'MTL_SYSTEM_ITEMS_INTERFACE',

846: request_id,
847: cr.TRANSACTION_ID,
848: error_msg,
849: 'INTERNAL_ORDER_ENABLED_FLAG',
850: 'MTL_SYSTEM_ITEMS_INTERFACE',
851: 'INV_INTERNAL_ENABLED',
852: err_text);
853: if dumm_status < 0 then
854: raise LOGGING_ERR;

Line 873: 'MTL_SYSTEM_ITEMS_INTERFACE',

869: request_id,
870: cr.TRANSACTION_ID,
871: error_msg,
872: 'PICK_COMPONENTS_FLAG',
873: 'MTL_SYSTEM_ITEMS_INTERFACE',
874: 'INV_PICK_COMPONENTS_FLAG',
875: err_text);
876: if dumm_status < 0 then
877: raise LOGGING_ERR;

Line 896: 'MTL_SYSTEM_ITEMS_INTERFACE',

892: request_id,
893: cr.TRANSACTION_ID,
894: error_msg,
895: 'CONTAINER_ITEM_FLAG',
896: 'MTL_SYSTEM_ITEMS_INTERFACE',
897: 'INV_IOI_FLAG_Y_N',
898: err_text);
899: if dumm_status < 0 then
900: raise LOGGING_ERR;

Line 917: 'MTL_SYSTEM_ITEMS_INTERFACE',

913: request_id,
914: cr.TRANSACTION_ID,
915: error_msg,
916: 'VEHICLE_ITEM_FLAG',
917: 'MTL_SYSTEM_ITEMS_INTERFACE',
918: 'INV_IOI_FLAG_Y_N',
919: err_text);
920: if dumm_status < 0 then
921: raise LOGGING_ERR;

Line 939: 'MTL_SYSTEM_ITEMS_INTERFACE',

935: request_id,
936: cr.TRANSACTION_ID,
937: error_msg,
938: 'MINIMUM_FILL_PERCENTAGE',
939: 'MTL_SYSTEM_ITEMS_INTERFACE',
940: 'INV_IOI_MIN_FILL_PERCENT',
941: err_text);
942: if dumm_status < 0 then
943: raise LOGGING_ERR;

Line 961: 'MTL_SYSTEM_ITEMS_INTERFACE',

957: request_id,
958: cr.TRANSACTION_ID,
959: error_msg,
960: 'CONTAINER_ITEM_CODE',
961: 'MTL_SYSTEM_ITEMS_INTERFACE',
962: 'INV_CONTAINER',
963: err_text);
964: if dumm_status < 0 then
965: raise LOGGING_ERR;

Line 984: 'MTL_SYSTEM_ITEMS_INTERFACE',

980: request_id,
981: cr.TRANSACTION_ID,
982: error_msg,
983: 'MAXIMUM_LOAD_WEIGHT',
984: 'MTL_SYSTEM_ITEMS_INTERFACE',
985: 'INV_CONTAINER_OR_VEHICLE',
986: err_text);
987: if dumm_status < 0 then
988: raise LOGGING_ERR;

Line 1007: 'MTL_SYSTEM_ITEMS_INTERFACE',

1003: request_id,
1004: cr.TRANSACTION_ID,
1005: error_msg,
1006: 'MINIMUM_FILL_PERCENT',
1007: 'MTL_SYSTEM_ITEMS_INTERFACE',
1008: 'INV_CONTAINER_OR_VEHICLE',
1009: err_text);
1010: if dumm_status < 0 then
1011: raise LOGGING_ERR;

Line 1030: 'MTL_SYSTEM_ITEMS_INTERFACE',

1026: request_id,
1027: cr.TRANSACTION_ID,
1028: error_msg,
1029: 'INTERNAL_VOLUME',
1030: 'MTL_SYSTEM_ITEMS_INTERFACE',
1031: 'INV_CONTAINER_OR_VEHICLE',
1032: err_text);
1033: if dumm_status < 0 then
1034: raise LOGGING_ERR;

Line 1052: 'MTL_SYSTEM_ITEMS_INTERFACE',

1048: request_id,
1049: cr.TRANSACTION_ID,
1050: error_msg,
1051: 'RELEASE_TIME_FENCE_CODE',
1052: 'MTL_SYSTEM_ITEMS_INTERFACE',
1053: 'INV_IOI_REL_TIME_FENCE_CODE',
1054: err_text);
1055: if dumm_status < 0 then
1056: raise LOGGING_ERR;

Line 1074: 'MTL_SYSTEM_ITEMS_INTERFACE',

1070: request_id,
1071: cr.TRANSACTION_ID,
1072: error_msg,
1073: 'RELEASE_TIME_FENCE_DAYS',
1074: 'MTL_SYSTEM_ITEMS_INTERFACE',
1075: 'INV_RELEASE_DAYS',
1076: err_text);
1077: if dumm_status < 0 then
1078: raise LOGGING_ERR;

Line 1101: 'MTL_SYSTEM_ITEMS_INTERFACE',

1097: request_id,
1098: cr.TRANSACTION_ID,
1099: error_msg,
1100: 'RELEASE_TIME_FENCE_DAYS',
1101: 'MTL_SYSTEM_ITEMS_INTERFACE',
1102: 'INV_IOI_RELEASE_TM_FENCE_DAYS',
1103: err_text);
1104: if dumm_status < 0 then
1105: raise LOGGING_ERR;

Line 1124: 'MTL_SYSTEM_ITEMS_INTERFACE',

1120: request_id,
1121: cr.TRANSACTION_ID,
1122: error_msg,
1123: 'PICK_COMPONENTS_FLAG',
1124: 'MTL_SYSTEM_ITEMS_INTERFACE',
1125: 'INV_IOI_PICK_COMPONENTS_FLAG',
1126: err_text);
1127: if dumm_status < 0 then
1128: raise LOGGING_ERR;

Line 1147: 'MTL_SYSTEM_ITEMS_INTERFACE',

1143: request_id,
1144: cr.TRANSACTION_ID,
1145: error_msg,
1146: 'SHRINKAGE_RATE',
1147: 'MTL_SYSTEM_ITEMS_INTERFACE',
1148: 'INV_SHRINKAGE_RATE_ERR',
1149: err_text);
1150: if dumm_status < 0 then
1151: raise LOGGING_ERR;

Line 1167: from MTL_SYSTEM_ITEMS_INTERFACE

1163: ** 31, 41 :set by INVPVHDR
1164: */
1165: /* Bug 4705184. Get the process_flag value from cursor itself.
1166: select process_flag into temp_proc_flag
1167: from MTL_SYSTEM_ITEMS_INTERFACE
1168: where inventory_item_id = l_item_id
1169: and set_process_id + 0 = xset_id
1170: and process_flag in (31,41)
1171: and organization_id = cr.organization_id

Line 1181: update MTL_SYSTEM_ITEMS_INTERFACE

1177: ** already failed in one of the previous packages.
1178: */
1179:
1180: if temp_proc_flag <> 31 then
1181: update MTL_SYSTEM_ITEMS_INTERFACE
1182: set process_flag = DECODE(status,0,42,32),
1183: PRIMARY_UOM_CODE = cr.primary_uom_code,
1184: primary_unit_of_measure = cr.primary_unit_of_measure
1185: where inventory_item_id = l_item_id

Line 1208: 'MTL_SYSTEM_ITEMS_INTERFACE',

1204: request_id,
1205: trans_id,
1206: err_text,
1207: 'validation_error ' || stmt,
1208: 'MTL_SYSTEM_ITEMS_INTERFACE',
1209: 'BOM_OP_VALIDATION_ERR',
1210: err_text);
1211: return(status);
1212: when OTHERS then