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.INVPVLM3 dependencies on MTL_SYSTEM_ITEMS

Line 118: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp

114: msii.EXPIRATION_ACTION_CODE ,
115: msii.MATURITY_DAYS ,
116: msii.HOLD_DAYS
117: /* End Bug 3713912 */
118: from MTL_SYSTEM_ITEMS_INTERFACE msii, MTL_PARAMETERS mp
119: where ((msii.organization_id = org_id) or
120: (all_Org = 1))
121: and msii.process_flag = 2
122: and msii.organization_id = mp.organization_id

Line 244: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';

240: /* End Bug 3713912 */
241:
242: begin
243:
244: error_msg := 'Validation error in validating MTL_SYSTEM_ITEMS_INTERFACE with ';
245:
246: /* set the attribute level variables to be used when validating a child's item
247: ** level attributes against the master org's attribute value. this is done
248: ** outside the loop so that it is only done once for all the records

Line 529: from mtl_system_items msi

525:
526: begin /* MASTER_CHILD_7A */
527:
528: select inventory_item_id into msicount
529: from mtl_system_items msi
530: where msi.inventory_item_id = cr.III
531: and msi.organization_id = cr.MORGID
532: and decode(A_ENGINEERING_DATE,X_TRUE,nvl(cr.ENGINEERING_DATE,TO_DATE('1000/01/01','YYYY/MM/DD')),nvl(msi.ENGINEERING_DATE,TO_DATE('1000/01/01','YYYY/MM/DD')))=nvl(msi.ENGINEERING_DATE,TO_DATE('1000/01/01','YYYY/MM/DD'))
533: and decode(A_NEGATIVE_MEASUREMENT_ERROR,X_TRUE,nvl(cr.NEGATIVE_MEASUREMENT_ERROR,-1),nvl(msi.NEGATIVE_MEASUREMENT_ERROR,-1))=nvl(msi.NEGATIVE_MEASUREMENT_ERROR,-1)

Line 551: 'MTL_SYSTEM_ITEMS_INTERFACE',

547: request_id,
548: cr.TRANSACTION_ID,
549: error_msg,
550: 'MASTER_CHILD_7A',
551: 'MTL_SYSTEM_ITEMS_INTERFACE',
552: 'INV_IOI_MASTER_CHILD_7A',
553: err_text);
554: If dumm_status < 0 then
555: raise LOGGING_ERR ;

Line 557: update mtl_system_items_interface msii

553: err_text);
554: If dumm_status < 0 then
555: raise LOGGING_ERR ;
556: End if;
557: update mtl_system_items_interface msii
558: set process_flag = 3
559: where msii.transaction_id = cr.transaction_id;
560:
561: end; /* MASTER_CHILD_7A */

Line 567: from mtl_system_items msi

563:
564: begin /* MASTER_CHILD_7B */
565:
566: select inventory_item_id into msicount
567: from mtl_system_items msi
568: where msi.inventory_item_id = cr.III
569: and msi.organization_id = cr.MORGID
570: and decode(A_SERVICEABLE_PRODUCT_FLAG,X_TRUE,nvl(cr.SERVICEABLE_PRODUCT_FLAG,-1),nvl(msi.SERVICEABLE_PRODUCT_FLAG,-1))=nvl(msi.SERVICEABLE_PRODUCT_FLAG,-1)
571: and decode(A_BASE_WARRANTY_SERVICE_ID,X_TRUE,nvl(cr.BASE_WARRANTY_SERVICE_ID,-1),nvl(msi.BASE_WARRANTY_SERVICE_ID,-1))=nvl(msi.BASE_WARRANTY_SERVICE_ID,-1)

Line 590: 'MTL_SYSTEM_ITEMS_INTERFACE',

586: request_id,
587: cr.TRANSACTION_ID,
588: error_msg,
589: 'MASTER_CHILD_7B',
590: 'MTL_SYSTEM_ITEMS_INTERFACE',
591: 'INV_IOI_MASTER_CHILD_7B',
592: err_text);
593: If dumm_status < 0 then
594: raise LOGGING_ERR ;

Line 596: update mtl_system_items_interface msii

592: err_text);
593: If dumm_status < 0 then
594: raise LOGGING_ERR ;
595: End if;
596: update mtl_system_items_interface msii
597: set process_flag = 3
598: where msii.transaction_id = cr.transaction_id;
599:
600: end; /* MASTER_CHILD_7B */

Line 605: from mtl_system_items msi

601:
602: begin /* MASTER_CHILD_7C */
603:
604: select inventory_item_id into msicount
605: from mtl_system_items msi
606: where msi.inventory_item_id = cr.III
607: and msi.organization_id = cr.MORGID
608: --Bug 4496767 and decode(A_TIME_BILLABLE_FLAG,X_TRUE,nvl(cr.TIME_BILLABLE_FLAG,-1),nvl(msi.TIME_BILLABLE_FLAG,-1))=nvl(msi.TIME_BILLABLE_FLAG,-1)
609: and decode(A_MATERIAL_BILLABLE_FLAG,X_TRUE,nvl(cr.MATERIAL_BILLABLE_FLAG,-1),nvl(msi.MATERIAL_BILLABLE_FLAG,-1))=nvl(msi.MATERIAL_BILLABLE_FLAG,-1)

Line 629: 'MTL_SYSTEM_ITEMS_INTERFACE',

625: request_id,
626: cr.TRANSACTION_ID,
627: error_msg,
628: 'MASTER_CHILD_7C',
629: 'MTL_SYSTEM_ITEMS_INTERFACE',
630: 'INV_IOI_MASTER_CHILD_7C',
631: err_text);
632: If dumm_status < 0 then
633: raise LOGGING_ERR ;

Line 635: update mtl_system_items_interface msii

631: err_text);
632: If dumm_status < 0 then
633: raise LOGGING_ERR ;
634: End if;
635: update mtl_system_items_interface msii
636: set process_flag = 3
637: where msii.transaction_id = cr.transaction_id;
638:
639: end; /* MASTER_CHILD_7C */

Line 644: from mtl_system_items msi

640:
641: begin /* MASTER_CHILD_7D */
642:
643: select inventory_item_id into msicount
644: from mtl_system_items msi
645: where msi.inventory_item_id = cr.III
646: and msi.organization_id = cr.MORGID
647: and decode(A_MAX_WARRANTY_AMOUNT,X_TRUE,nvl(cr.MAX_WARRANTY_AMOUNT,-1),nvl(msi.MAX_WARRANTY_AMOUNT,-1))=nvl(msi.MAX_WARRANTY_AMOUNT,-1)
648: and decode(A_RESPONSE_TIME_PERIOD_CODE,X_TRUE,nvl(cr.RESPONSE_TIME_PERIOD_CODE,-1),nvl(msi.RESPONSE_TIME_PERIOD_CODE,-1))=nvl(msi.RESPONSE_TIME_PERIOD_CODE,-1)

Line 668: 'MTL_SYSTEM_ITEMS_INTERFACE',

664: request_id,
665: cr.TRANSACTION_ID,
666: error_msg,
667: 'MASTER_CHILD_7D',
668: 'MTL_SYSTEM_ITEMS_INTERFACE',
669: 'INV_IOI_MASTER_CHILD_7D',
670: err_text);
671: If dumm_status < 0 then
672: raise LOGGING_ERR ;

Line 674: update mtl_system_items_interface msii

670: err_text);
671: If dumm_status < 0 then
672: raise LOGGING_ERR ;
673: End if;
674: update mtl_system_items_interface msii
675: set process_flag = 3
676: where msii.transaction_id = cr.transaction_id;
677:
678: end; /* MASTER_CHILD_7D */

Line 684: from mtl_system_items msi

680:
681: begin /* MASTER_CHILD_7E */
682:
683: select inventory_item_id into msicount
684: from mtl_system_items msi
685: where msi.inventory_item_id = cr.III
686: and msi.organization_id = cr.MORGID
687: and decode(A_RELEASE_TIME_FENCE_CODE,X_TRUE,nvl(cr.RELEASE_TIME_FENCE_CODE,-1),nvl(msi.RELEASE_TIME_FENCE_CODE,-1))=nvl(msi.RELEASE_TIME_FENCE_CODE,-1)
688: and decode(A_RELEASE_TIME_FENCE_DAYS,X_TRUE,nvl(cr.RELEASE_TIME_FENCE_DAYS,-1),nvl(msi.RELEASE_TIME_FENCE_DAYS,-1))=nvl(msi.RELEASE_TIME_FENCE_DAYS,-1)

Line 708: 'MTL_SYSTEM_ITEMS_INTERFACE',

704: request_id,
705: cr.TRANSACTION_ID,
706: error_msg,
707: 'MASTER_CHILD_7E',
708: 'MTL_SYSTEM_ITEMS_INTERFACE',
709: 'INV_IOI_MASTER_CHILD_7E',
710: err_text);
711: If dumm_status < 0 then
712: raise LOGGING_ERR ;

Line 714: update mtl_system_items_interface msii

710: err_text);
711: If dumm_status < 0 then
712: raise LOGGING_ERR ;
713: End if;
714: update mtl_system_items_interface msii
715: set process_flag = 3
716: where msii.transaction_id = cr.transaction_id;
717:
718: end; /* MASTER_CHILD_7E */

Line 723: from mtl_system_items msi

719: -- Added for 11.5.10
720: begin /* MASTER_CHILD_7F */
721:
722: select inventory_item_id into msicount
723: from mtl_system_items msi
724: where msi.inventory_item_id = cr.III
725: and msi.organization_id = cr.MORGID
726: and decode(A_TRACKING_QUANTITY_IND,X_TRUE,nvl(cr.TRACKING_QUANTITY_IND,-1),nvl(msi.TRACKING_QUANTITY_IND,-1))=nvl(msi.TRACKING_QUANTITY_IND,-1)
727: and decode(A_ONT_PRICING_QTY_SOURCE,X_TRUE,nvl(cr.ONT_PRICING_QTY_SOURCE,-1),nvl(msi.ONT_PRICING_QTY_SOURCE,-1))=nvl(msi.ONT_PRICING_QTY_SOURCE,-1)

Line 741: 'MTL_SYSTEM_ITEMS_INTERFACE',

737: request_id,
738: cr.TRANSACTION_ID,
739: error_msg,
740: 'MASTER_CHILD_7F',
741: 'MTL_SYSTEM_ITEMS_INTERFACE',
742: 'INV_IOI_MASTER_CHILD_7F',
743: err_text);
744: If dumm_status < 0 then
745: raise LOGGING_ERR ;

Line 747: update mtl_system_items_interface msii

743: err_text);
744: If dumm_status < 0 then
745: raise LOGGING_ERR ;
746: End if;
747: update mtl_system_items_interface msii
748: set process_flag = 3
749: where msii.transaction_id = cr.transaction_id;
750:
751: end; /* MASTER_CHILD_7F */

Line 756: from mtl_system_items msi

752:
753: begin /* MASTER_CHILD_7G */
754:
755: select inventory_item_id into msicount
756: from mtl_system_items msi
757: where msi.inventory_item_id = cr.III
758: and msi.organization_id = cr.MORGID
759: and decode(A_CONFIG_ORGS,X_TRUE,nvl(cr.CONFIG_ORGS,-1),nvl(msi.CONFIG_ORGS,-1))=nvl(msi.CONFIG_ORGS,-1)
760: and decode(A_CONFIG_MATCH,X_TRUE,nvl(cr.CONFIG_MATCH,-1),nvl(msi.CONFIG_MATCH,-1))=nvl(msi.CONFIG_MATCH,-1);

Line 773: 'MTL_SYSTEM_ITEMS_INTERFACE',

769: request_id,
770: cr.TRANSACTION_ID,
771: error_msg,
772: 'MASTER_CHILD_7G',
773: 'MTL_SYSTEM_ITEMS_INTERFACE',
774: 'INV_IOI_MASTER_CHILD_7G',
775: err_text);
776: If dumm_status < 0 then
777: raise LOGGING_ERR ;

Line 779: update mtl_system_items_interface msii

775: err_text);
776: If dumm_status < 0 then
777: raise LOGGING_ERR ;
778: End if;
779: update mtl_system_items_interface msii
780: set process_flag = 3
781: where msii.transaction_id = cr.transaction_id;
782:
783: end; /* MASTER_CHILD_7G */

Line 788: from mtl_system_items msi

784:
785: begin /* MASTER_CHILD_7H */
786:
787: select inventory_item_id into msicount
788: from mtl_system_items msi
789: where msi.inventory_item_id = cr.III
790: and msi.organization_id = cr.MORGID
791: and decode(A_SO_AUTHORIZATION_FLAG,X_TRUE,nvl(cr.SO_AUTHORIZATION_FLAG,-1),nvl(msi.SO_AUTHORIZATION_FLAG,-1))=nvl(msi.SO_AUTHORIZATION_FLAG,-1)
792: and decode(A_VMI_MINIMUM_UNITS,X_TRUE,nvl(cr.VMI_MINIMUM_UNITS,-1),nvl(msi.VMI_MINIMUM_UNITS,-1))=nvl(msi.VMI_MINIMUM_UNITS,-1)

Line 823: 'MTL_SYSTEM_ITEMS_INTERFACE',

819: request_id,
820: cr.TRANSACTION_ID,
821: error_msg,
822: 'MASTER_CHILD_7G',
823: 'MTL_SYSTEM_ITEMS_INTERFACE',
824: 'INV_IOI_MASTER_CHILD_7H',
825: err_text);
826: If dumm_status < 0 then
827: raise LOGGING_ERR ;

Line 829: update mtl_system_items_interface msii

825: err_text);
826: If dumm_status < 0 then
827: raise LOGGING_ERR ;
828: End if;
829: update mtl_system_items_interface msii
830: set process_flag = 3
831: where msii.transaction_id = cr.transaction_id;
832:
833: end; /* MASTER_CHILD_7H */

Line 839: from mtl_system_items msi

835: /* Start Bug 3713912 */
836: begin /* MASTER_CHILD_7I */
837:
838: select inventory_item_id into msicount
839: from mtl_system_items msi
840: where msi.inventory_item_id = cr.III
841: and msi.organization_id = cr.MORGID
842: and decode(A_LOT_DIVISIBLE_FLAG ,X_TRUE,nvl(cr.LOT_DIVISIBLE_FLAG ,-1),nvl(msi.LOT_DIVISIBLE_FLAG ,-1))= nvl(msi.LOT_DIVISIBLE_FLAG,-1)
843: and decode(A_GRADE_CONTROL_FLAG ,X_TRUE,nvl(cr.GRADE_CONTROL_FLAG ,-1),nvl(msi.GRADE_CONTROL_FLAG ,-1))= nvl(msi.GRADE_CONTROL_FLAG,-1)

Line 866: 'MTL_SYSTEM_ITEMS_INTERFACE',

862: request_id,
863: cr.TRANSACTION_ID,
864: error_msg,
865: 'MASTER_CHILD_7I',
866: 'MTL_SYSTEM_ITEMS_INTERFACE',
867: 'INV_IOI_MASTER_CHILD_7I',
868: err_text);
869: If dumm_status < 0 then
870: raise LOGGING_ERR ;

Line 872: update mtl_system_items_interface msii

868: err_text);
869: If dumm_status < 0 then
870: raise LOGGING_ERR ;
871: End if;
872: update mtl_system_items_interface msii
873: set process_flag = 3
874: where msii.transaction_id = cr.transaction_id;
875:
876: end; /* MASTER_CHILD_7I */

Line 883: from mtl_system_items msi

879: /* Start Bug 3713912 */
880: begin /* MASTER_CHILD_7J */
881:
882: select inventory_item_id into msicount
883: from mtl_system_items msi
884: where msi.inventory_item_id = cr.III
885: and msi.organization_id = cr.MORGID
886: and decode(A_PROCESS_COSTING_ENABLED_FLAG ,X_TRUE,nvl(cr.PROCESS_COSTING_ENABLED_FLAG,-1),nvl(msi.PROCESS_COSTING_ENABLED_FLAG,-1))= nvl(msi.PROCESS_COSTING_ENABLED_FLAG,-1)
887: and decode(A_HAZARDOUS_MATERIAL_FLAG ,X_TRUE,nvl(cr.HAZARDOUS_MATERIAL_FLAG,-1),nvl(msi.HAZARDOUS_MATERIAL_FLAG,-1))= nvl(msi.HAZARDOUS_MATERIAL_FLAG,-1)

Line 906: 'MTL_SYSTEM_ITEMS_INTERFACE',

902: request_id,
903: cr.TRANSACTION_ID,
904: error_msg,
905: 'MASTER_CHILD_7J',
906: 'MTL_SYSTEM_ITEMS_INTERFACE',
907: 'INV_IOI_MASTER_CHILD_7J',
908: err_text);
909: If dumm_status < 0 then
910: raise LOGGING_ERR ;

Line 912: update mtl_system_items_interface msii

908: err_text);
909: If dumm_status < 0 then
910: raise LOGGING_ERR ;
911: End if;
912: update mtl_system_items_interface msii
913: set process_flag = 3
914: where msii.transaction_id = cr.transaction_id;
915:
916: end; /* MASTER_CHILD_7J */

Line 936: 'MTL_SYSTEM_ITEMS_INTERFACE',

932: request_id,
933: trans_id,
934: err_text,
935: 'MASTER_CHILD_7',
936: 'MTL_SYSTEM_ITEMS_INTERFACE',
937: 'BOM_OP_VALIDATION_ERR',
938: err_text);
939: return(status);
940: when OTHERS then