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_ENC_ACCT_REQ', --bug 11894684, replace 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 664: 'MTL_SYSTEM_ITEMS_INTERFACE',

660: request_id,
661: cr.TRANSACTION_ID,
662: error_msg,
663: 'EXPENSE_ACCOUNT',
664: 'MTL_SYSTEM_ITEMS_INTERFACE',
665: 'INV_EXP_ACCT_REQ', -- fix for BUG 3069139
666: err_text);
667: if dumm_status < 0 then
668: raise LOGGING_ERR;

Line 688: 'MTL_SYSTEM_ITEMS_INTERFACE',

684: request_id,
685: cr.TRANSACTION_ID,
686: error_msg,
687: 'INVENTORY_ASSET_FLAG',
688: 'MTL_SYSTEM_ITEMS_INTERFACE',
689: 'INV_COST_ASSET',
690: err_text);
691: if dumm_status < 0 then
692: raise LOGGING_ERR;

Line 711: 'MTL_SYSTEM_ITEMS_INTERFACE',

707: request_id,
708: cr.TRANSACTION_ID,
709: error_msg,
710: 'POSTPROCESSING_LEADTIME',
711: 'MTL_SYSTEM_ITEMS_INTERFACE',
712: 'INV_IOI_POST_PROC_LEAD_TIME',
713: err_text);
714: if dumm_status < 0 then
715: raise LOGGING_ERR;

Line 734: 'MTL_SYSTEM_ITEMS_INTERFACE',

730: request_id,
731: cr.TRANSACTION_ID,
732: error_msg,
733: 'LEAD_TIME_LOT_SIZE',
734: 'MTL_SYSTEM_ITEMS_INTERFACE',
735: 'INV_IOI_LEAD_TIME_LOT_SIZE',
736: err_text);
737: if dumm_status < 0 then
738: raise LOGGING_ERR;

Line 760: 'MTL_SYSTEM_ITEMS_INTERFACE',

756: request_id,
757: cr.TRANSACTION_ID,
758: error_msg,
759: 'ATP_COMPONENTS_FLAG1',
760: 'MTL_SYSTEM_ITEMS_INTERFACE',
761: 'INV_IOI_ATP_COMPS',
762: err_text);
763: if dumm_status < 0 then
764: raise LOGGING_ERR;

Line 790: 'MTL_SYSTEM_ITEMS_INTERFACE',

786: request_id,
787: cr.TRANSACTION_ID,
788: error_msg,
789: 'ATP_COMPONENTS_FLAG1',
790: 'MTL_SYSTEM_ITEMS_INTERFACE',
791: 'INV_ATP_COMPS',
792: err_text);
793: if dumm_status < 0 then
794: raise LOGGING_ERR;

Line 813: 'MTL_SYSTEM_ITEMS_INTERFACE',

809: request_id,
810: cr.TRANSACTION_ID,
811: error_msg,
812: 'REPETITIVE_PLANNING_FLAG',
813: 'MTL_SYSTEM_ITEMS_INTERFACE',
814: 'INV_REPETITIVE_MAND',
815: err_text);
816: if dumm_status < 0 then
817: raise LOGGING_ERR;

Line 835: 'MTL_SYSTEM_ITEMS_INTERFACE',

831: request_id,
832: cr.TRANSACTION_ID,
833: error_msg,
834: 'MTL_TRANSACTIONS_ENABLED_FLAG',
835: 'MTL_SYSTEM_ITEMS_INTERFACE',
836: 'INV_TRX',
837: err_text);
838: if dumm_status < 0 then
839: raise LOGGING_ERR;

Line 857: 'MTL_SYSTEM_ITEMS_INTERFACE',

853: request_id,
854: cr.TRANSACTION_ID,
855: error_msg,
856: 'INTERNAL_ORDER_ENABLED_FLAG',
857: 'MTL_SYSTEM_ITEMS_INTERFACE',
858: 'INV_INTERNAL_ENABLED',
859: err_text);
860: if dumm_status < 0 then
861: raise LOGGING_ERR;

Line 880: 'MTL_SYSTEM_ITEMS_INTERFACE',

876: request_id,
877: cr.TRANSACTION_ID,
878: error_msg,
879: 'PICK_COMPONENTS_FLAG',
880: 'MTL_SYSTEM_ITEMS_INTERFACE',
881: 'INV_PICK_COMPONENTS_FLAG',
882: err_text);
883: if dumm_status < 0 then
884: raise LOGGING_ERR;

Line 903: 'MTL_SYSTEM_ITEMS_INTERFACE',

899: request_id,
900: cr.TRANSACTION_ID,
901: error_msg,
902: 'CONTAINER_ITEM_FLAG',
903: 'MTL_SYSTEM_ITEMS_INTERFACE',
904: 'INV_IOI_FLAG_Y_N',
905: err_text);
906: if dumm_status < 0 then
907: raise LOGGING_ERR;

Line 924: 'MTL_SYSTEM_ITEMS_INTERFACE',

920: request_id,
921: cr.TRANSACTION_ID,
922: error_msg,
923: 'VEHICLE_ITEM_FLAG',
924: 'MTL_SYSTEM_ITEMS_INTERFACE',
925: 'INV_IOI_FLAG_Y_N',
926: err_text);
927: if dumm_status < 0 then
928: raise LOGGING_ERR;

Line 946: 'MTL_SYSTEM_ITEMS_INTERFACE',

942: request_id,
943: cr.TRANSACTION_ID,
944: error_msg,
945: 'MINIMUM_FILL_PERCENTAGE',
946: 'MTL_SYSTEM_ITEMS_INTERFACE',
947: 'INV_IOI_MIN_FILL_PERCENT',
948: err_text);
949: if dumm_status < 0 then
950: raise LOGGING_ERR;

Line 968: 'MTL_SYSTEM_ITEMS_INTERFACE',

964: request_id,
965: cr.TRANSACTION_ID,
966: error_msg,
967: 'CONTAINER_ITEM_CODE',
968: 'MTL_SYSTEM_ITEMS_INTERFACE',
969: 'INV_CONTAINER',
970: err_text);
971: if dumm_status < 0 then
972: raise LOGGING_ERR;

Line 991: 'MTL_SYSTEM_ITEMS_INTERFACE',

987: request_id,
988: cr.TRANSACTION_ID,
989: error_msg,
990: 'MAXIMUM_LOAD_WEIGHT',
991: 'MTL_SYSTEM_ITEMS_INTERFACE',
992: 'INV_CONTAINER_OR_VEHICLE',
993: err_text);
994: if dumm_status < 0 then
995: raise LOGGING_ERR;

Line 1014: 'MTL_SYSTEM_ITEMS_INTERFACE',

1010: request_id,
1011: cr.TRANSACTION_ID,
1012: error_msg,
1013: 'MINIMUM_FILL_PERCENT',
1014: 'MTL_SYSTEM_ITEMS_INTERFACE',
1015: 'INV_CONTAINER_OR_VEHICLE',
1016: err_text);
1017: if dumm_status < 0 then
1018: raise LOGGING_ERR;

Line 1037: 'MTL_SYSTEM_ITEMS_INTERFACE',

1033: request_id,
1034: cr.TRANSACTION_ID,
1035: error_msg,
1036: 'INTERNAL_VOLUME',
1037: 'MTL_SYSTEM_ITEMS_INTERFACE',
1038: 'INV_CONTAINER_OR_VEHICLE',
1039: err_text);
1040: if dumm_status < 0 then
1041: raise LOGGING_ERR;

Line 1059: 'MTL_SYSTEM_ITEMS_INTERFACE',

1055: request_id,
1056: cr.TRANSACTION_ID,
1057: error_msg,
1058: 'RELEASE_TIME_FENCE_CODE',
1059: 'MTL_SYSTEM_ITEMS_INTERFACE',
1060: 'INV_IOI_REL_TIME_FENCE_CODE',
1061: err_text);
1062: if dumm_status < 0 then
1063: raise LOGGING_ERR;

Line 1081: 'MTL_SYSTEM_ITEMS_INTERFACE',

1077: request_id,
1078: cr.TRANSACTION_ID,
1079: error_msg,
1080: 'RELEASE_TIME_FENCE_DAYS',
1081: 'MTL_SYSTEM_ITEMS_INTERFACE',
1082: 'INV_RELEASE_DAYS',
1083: err_text);
1084: if dumm_status < 0 then
1085: raise LOGGING_ERR;

Line 1108: 'MTL_SYSTEM_ITEMS_INTERFACE',

1104: request_id,
1105: cr.TRANSACTION_ID,
1106: error_msg,
1107: 'RELEASE_TIME_FENCE_DAYS',
1108: 'MTL_SYSTEM_ITEMS_INTERFACE',
1109: 'INV_IOI_RELEASE_TM_FENCE_DAYS',
1110: err_text);
1111: if dumm_status < 0 then
1112: raise LOGGING_ERR;

Line 1131: 'MTL_SYSTEM_ITEMS_INTERFACE',

1127: request_id,
1128: cr.TRANSACTION_ID,
1129: error_msg,
1130: 'PICK_COMPONENTS_FLAG',
1131: 'MTL_SYSTEM_ITEMS_INTERFACE',
1132: 'INV_IOI_PICK_COMPONENTS_FLAG',
1133: err_text);
1134: if dumm_status < 0 then
1135: raise LOGGING_ERR;

Line 1154: 'MTL_SYSTEM_ITEMS_INTERFACE',

1150: request_id,
1151: cr.TRANSACTION_ID,
1152: error_msg,
1153: 'SHRINKAGE_RATE',
1154: 'MTL_SYSTEM_ITEMS_INTERFACE',
1155: 'INV_SHRINKAGE_RATE_ERR',
1156: err_text);
1157: if dumm_status < 0 then
1158: raise LOGGING_ERR;

Line 1174: from MTL_SYSTEM_ITEMS_INTERFACE

1170: ** 31, 41 :set by INVPVHDR
1171: */
1172: /* Bug 4705184. Get the process_flag value from cursor itself.
1173: select process_flag into temp_proc_flag
1174: from MTL_SYSTEM_ITEMS_INTERFACE
1175: where inventory_item_id = l_item_id
1176: and set_process_id + 0 = xset_id
1177: and process_flag in (31,41)
1178: and organization_id = cr.organization_id

Line 1188: update MTL_SYSTEM_ITEMS_INTERFACE

1184: ** already failed in one of the previous packages.
1185: */
1186:
1187: if temp_proc_flag <> 31 then
1188: update MTL_SYSTEM_ITEMS_INTERFACE
1189: set process_flag = DECODE(status,0,42,32),
1190: PRIMARY_UOM_CODE = cr.primary_uom_code,
1191: primary_unit_of_measure = cr.primary_unit_of_measure
1192: where inventory_item_id = l_item_id

Line 1216: 'MTL_SYSTEM_ITEMS_INTERFACE',

1212: request_id,
1213: trans_id,
1214: err_text,
1215: 'validation_error ' || stmt,
1216: 'MTL_SYSTEM_ITEMS_INTERFACE',
1217: 'BOM_OP_VALIDATION_ERR',
1218: err_text);
1219: return(status);
1220: when OTHERS then