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.BOM_DIAGUNITTEST_ECODATA dependencies on MTL_PARAMETERS

Line 56: from mtl_parameters

52:
53: If l_org_id is not null Then /* validate if input org_id exists*/
54: Begin
55: select 1 into l_org_exists
56: from mtl_parameters
57: where organization_id=l_org_id;
58: Exception
59: When others Then
60: l_org_exists :=0;

Line 239: ' , MTL_PARAMETERS MP1 '||

235: ' ,EEC.PROMOTE_STATUS_CODE "PROMOTE STATUS CODE" '||
236: ' ,EEC.IMPLEMENTATION_REQ_ID "IMPLEMENTATION REQ ID" '||
237: ' FROM eng_engineering_changes eec '||
238: ' , eng_change_order_types_v ecot '||
239: ' , MTL_PARAMETERS MP1 '||
240: ' , ENG_CHANGE_REASONS ECR '||
241: ' , ENG_CHANGE_PRIORITIES ECP '||
242: ' , ENG_ECN_APPROVAL_LISTS EEAL '||
243: ' , ENG_CHANGE_STATUSES_VL ECSVL '||

Line 389: ' ,MTL_PARAMETERS MP1 '||

385: ' ,ERI.IMPLEMENTATION_REQ_ID "IMPLEMENTATION REQ ID" '||
386: ' FROM ENG_REVISED_ITEMS ERI '||
387: ' ,MTL_ITEM_FLEXFIELDS MIF1 '||
388: ' ,MTL_ITEM_FLEXFIELDS MIF2 '||
389: ' ,MTL_PARAMETERS MP1 '||
390: ' ,ENG_CHANGE_STATUSES_VL ECSVL '||
391: ' WHERE 1=1 '||
392: ' AND ERI.ORGANIZATION_ID = MP1.ORGANIZATION_ID '||
393: ' AND ERI.REVISED_ITEM_ID = MIF1.INVENTORY_ITEM_ID '||

Line 535: ' MTL_PARAMETERS MP1, '||

531: ' ,BCB.PK4_VALUE "PK4 VALUE" '||
532: ' ,BCB.PK5_VALUE "PK5 VALUE" '||
533: ' FROM BOM_COMPONENTS_B BCB, '||
534: ' ENG_REVISED_ITEMS ERI, '||
535: ' MTL_PARAMETERS MP1, '||
536: ' MTL_ITEM_FLEXFIELDS MIF1, '||
537: ' MTL_ITEM_FLEXFIELDS MIF2, '||
538: ' MFG_LOOKUPS MLU_SO, '||
539: ' MFG_LOOKUPS MLU_ACD, '||

Line 591: ' MTL_PARAMETERS MP1, '||

587: ' ,BCB.BASIS_TYPE "BASIS TYPE" '||
588: ' ,BCB.COMMON_COMPONENT_SEQUENCE_ID "COMMON COMPONENT SEQUENCE ID" '||
589: ' FROM BOM_COMPONENTS_B BCB, '||
590: ' ENG_REVISED_ITEMS ERI, '||
591: ' MTL_PARAMETERS MP1, '||
592: ' MTL_ITEM_FLEXFIELDS MIF1, '||
593: ' MTL_ITEM_FLEXFIELDS MIF2, '||
594: ' MFG_LOOKUPS MLU_SO, '||
595: ' MFG_LOOKUPS MLU_ACD, '||

Line 672: ' ,MTL_PARAMETERS MP1 '||

668: ' ,BRD.COMMON_COMPONENT_SEQUENCE_ID "COMMON COMPONENT SEQUENCE ID" '||
669: ' FROM BOM_REFERENCE_DESIGNATORS BRD '||
670: ' ,BOM_COMPONENTS_B BCB '||
671: ' ,ENG_REVISED_ITEMS ERI '||
672: ' ,MTL_PARAMETERS MP1 '||
673: ' ,MTL_ITEM_FLEXFIELDS MIF1 '||
674: ' ,MTL_ITEM_FLEXFIELDS MIF2 '||
675: ' WHERE 1=1 '||
676: ' AND BCB.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID '||

Line 749: ' ,MTL_PARAMETERS MP1 '||

745: ' ,BSCO.COMMON_COMPONENT_SEQUENCE_ID "COMMON COMPONENT SEQUENCE ID" '||
746: ' FROM ENG_REVISED_ITEMS ERI '||
747: ' ,BOM_COMPONENTS_B BCB '||
748: ' ,BOM_SUBSTITUTE_COMPONENTS BSCO '||
749: ' ,MTL_PARAMETERS MP1 '||
750: ' ,MTL_ITEM_FLEXFIELDS MIF1 '||
751: ' ,MTL_ITEM_FLEXFIELDS MIF2 '||
752: ' ,MTL_ITEM_FLEXFIELDS MIF3 '||
753: ' ,MFG_LOOKUPS MLU_ACD '||

Line 885: ' ,mtl_parameters mp1 '||

881: ' ,BOS.SHOW_LOT_ATTRIB "SHOW LOT ATTRIB" '||
882: ' ,BOS.TRACK_MULTIPLE_RES_USAGE_DATES "TRACK MULTIPLE RES USAGE DATES" '||
883: ' FROM eng_revised_items eri '||
884: ' ,bom_operation_sequences bos '||
885: ' ,mtl_parameters mp1 '||
886: ' ,MTL_ITEM_FLEXFIELDS MIF1 '||
887: ' ,MFG_LOOKUPS MLU_BCPT '||
888: ' ,MFG_LOOKUPS MLU_OPT '||
889: ' ,MFG_LOOKUPS MLU_SHT '||

Line 982: ' , MTL_PARAMETERS MP1 '||

978: ' FROM eng_revised_items eri '||
979: ' , bom_operation_sequences bos '||
980: ' , bom_operation_resources bore '||
981: ' , bom_resources br '||
982: ' , MTL_PARAMETERS MP1 '||
983: ' , MTL_ITEM_FLEXFIELDS MIF1 '||
984: ' , MFG_LOOKUPS MLU_BT, MFG_LOOKUPS MLU_SF '||
985: ' , MFG_LOOKUPS MLU_ACT '||
986: ' WHERE 1=1 '||

Line 1052: ' ,mtl_parameters mp1 '||

1048: ' ,ECOR.CHANGE_ID "CHANGE ID" '||
1049: ' ,to_char(ECOR.START_DATE,''DD-MON-YYYY HH24:MI:SS'') "START DATE" '||
1050: ' ,to_char(ECOR.END_DATE,''DD-MON-YYYY HH24:MI:SS'') "END DATE" '||
1051: ' FROM eng_change_order_revisions ecor '||
1052: ' ,mtl_parameters mp1 '||
1053: ' WHERE 1=1 '||
1054: ' AND ecor.organization_id = mp1.organization_id '||
1055: ' AND ecor.change_notice = '''||l_eco_name||''' ';
1056:

Line 1097: ' ,MTL_PARAMETERS MP1 '||

1093: ' ,ECSD.ORIGINAL_SYSTEM_REFERENCE "ORIGINAL SYSTEM REFERENCE" '||
1094: ' ,ECSD.CHANGE_ID "CHANGE ID" '||
1095: ' ,ECSD.OLD_EMPLOYEE_ID "OLD EMPLOYEE ID" '||
1096: ' FROM ENG_CURRENT_SCHEDULED_DATES ECSD '||
1097: ' ,MTL_PARAMETERS MP1 '||
1098: ' ,MTL_ITEM_FLEXFIELDS MIF1 '||
1099: ' WHERE 1=1 '||
1100: ' AND MP1.ORGANIZATION_ID = ECSD.ORGANIZATION_ID '||
1101: ' AND ECSD.REVISED_ITEM_ID = MIF1.INVENTORY_ITEM_ID '||

Line 1162: ' ,MTL_PARAMETERS MP1 '||

1158: ' ,MRIR.PROGRAM_ID "PROGRAM ID" '||
1159: ' ,to_char(MRIR.PROGRAM_UPDATE_DATE,''DD-MON-YYYY HH24:MI:SS'') "PROGRAM UPDATE DATE" '||
1160: ' from eng_revised_items eri '||
1161: ' ,mtl_rtg_item_revisions mrir '||
1162: ' ,MTL_PARAMETERS MP1 '||
1163: ' ,MTL_ITEM_FLEXFIELDS MIF1 '||
1164: ' where 1=1 '||
1165: ' and mrir.inventory_item_id = eri.revised_item_id '||
1166: ' and mrir.organization_id = eri.organization_id '||

Line 1361: ' mtl_parameters mp1 '||

1357: ' to_char(EEAV.DISABLE_DATE,''DD-MON-YYYY HH24:MI:SS'') "DISABLE DATE (Approver)",'||
1358: ' EEAV.EMPLOYEE_ID "EMPLOYEE ID" '||
1359: ' from eng_engineering_changes_v eecv, '||
1360: ' eng_ecn_approval_lists eeal, eng_ecn_approvers_v eeav, '||
1361: ' mtl_parameters mp1 '||
1362: ' where eecv.approval_list_id=eeal.approval_list_id '||
1363: ' and eeal.approval_list_id=eeav.approval_list_id '||
1364: ' and eecv.organization_id = mp1.organization_id '||
1365: ' and eecv.change_notice='''||l_eco_name||''' ';

Line 1406: ' mtl_parameters mp1 '||

1402: ' ,to_char(WFR.EXPIRATION_DATE,''DD-MON-YYYY HH24:MI:SS'') "EXPIRATION DATE" '||
1403: ' ,WFR.PARTITION_ID "PARTITION ID" '||
1404: ' from eng_engineering_changes_v eecv, '||
1405: ' eng_ecn_approval_lists eeal, wf_roles wfr, '||
1406: ' mtl_parameters mp1 '||
1407: ' where eecv.approval_list_id=eeal.approval_list_id '||
1408: ' and eeal.approval_list_id=wfr.orig_system_id '||
1409: ' and wfr.orig_system=''ENG_LIST'' '||
1410: ' and eecv.organization_id = mp1.organization_id '||

Line 1452: ' mtl_parameters mp1 '||

1448: ' ,to_char(WFU.EXPIRATION_DATE,''DD-MON-YYYY HH24:MI:SS'')"EXPIRATION DATE" '||
1449: ' ,WFU.PARTITION_ID "PARTITION ID" '||
1450: ' from eng_engineering_changes_v eecv, '||
1451: ' eng_ecn_approvers_v eea , wf_users wfu, '||
1452: ' mtl_parameters mp1 '||
1453: ' where eecv.approval_list_id=eea.approval_list_id '||
1454: ' and eea.employee_id=wfu.orig_system_id '||
1455: ' and eecv.organization_id = mp1.organization_id '||
1456: ' and eecv.change_notice='''||l_eco_name||''' ';

Line 1493: ' mtl_parameters mp1 '||

1489: ' ,WFUR.PARTITION_ID "PARTITION ID" '||
1490: ' ,WFUR.ASSIGNMENT_REASON "ASSIGNMENT REASON" '||
1491: 'from wf_user_roles wfur, eng_ecn_approvers_v eeav, '||
1492: ' eng_engineering_changes_v eecv, '||
1493: ' mtl_parameters mp1 '||
1494: 'where wfur.user_orig_system_id=eeav.employee_id '||
1495: 'and wfur.role_orig_system_id=eeav.approval_list_id '||
1496: 'and wfur.role_orig_system=''ENG_LIST'' '||
1497: 'and eeav.approval_list_id= eecv.approval_list_id '||

Line 1536: ' ,mtl_parameters mp1 '||

1532: ' FROM PER_ORGANIZATION_STRUCTURES OS '||
1533: ' ,PER_ORG_STRUCTURE_VERSIONS OSV '||
1534: ' ,PER_ORG_STRUCTURE_ELEMENTS_V OSE '||
1535: ' ,ENG_ENGINEERING_CHANGES EEC '||
1536: ' ,mtl_parameters mp1 '||
1537: ' WHERE 1=1 '||
1538: ' AND OS.ORGANIZATION_STRUCTURE_ID = OSV.ORGANIZATION_STRUCTURE_ID '||
1539: ' AND OSV.ORG_STRUCTURE_VERSION_ID = OSE.ORG_STRUCTURE_VERSION_ID '||
1540: ' AND OS.NAME = EEC.ORGANIZATION_HIERARCHY '||

Line 1568: ' ,MTL_PARAMETERS MP '||

1564: ' ,to_char(MBP.USE_UP_DATE,''DD-MON-YYYY HH24:MI:SS'') "Use Up Date" '||
1565: ' ,MBP.ITEM_ID "Item Id" '||
1566: ' ,MBP.ORGANIZATION_ID "Org Id" '||
1567: ' FROM MRP_BOM_PLAN_NAME_LOV_V MBP '||
1568: ' ,MTL_PARAMETERS MP '||
1569: ' WHERE MBP.ORGANIZATION_ID = MP.ORGANIZATION_ID(+) '||
1570: ' AND ( MBP.Organization_Id, MBP.Item_Id) in '||
1571: ' ( '||
1572: ' SELECT eri.organization_id, BCB.component_item_id '||

Line 1675: ' ,MTL_PARAMETERS MP '||

1671: ' ,ERIIV.LAST_UPDATE_LOGIN "Last Update Login" '||
1672: ' FROM '||
1673: ' ENG_ENG_CHANGES_INTERFACE_V EECIV '||
1674: ' ,ENG_REVISED_ITEMS_INTERFACE_V ERIIV '||
1675: ' ,MTL_PARAMETERS MP '||
1676: ' WHERE '||
1677: ' EECIV.CHANGE_NOTICE = ERIIV.CHANGE_NOTICE '||
1678: ' AND EECIV.ORGANIZATION_ID = ERIIV.ORGANIZATION_ID '||
1679: ' AND EECIV.ORGANIZATION_ID = MP.ORGANIZATION_ID '||

Line 1780: ' ,MTL_PARAMETERS MP '||

1776: ' ,to_char(BICO.PROGRAM_UPDATE_DATE,''DD-MON-YYYY HH24:MI:SS'') "Program Update Date" '||
1777: ' FROM '||
1778: ' BOM_INV_COMPS_INTERFACE_V BICO '||
1779: ' ,ENG_REVISED_ITEMS_INTERFACE ERI '||
1780: ' ,MTL_PARAMETERS MP '||
1781: ' ,MTL_ITEM_FLEXFIELDS MIF '||
1782: ' ,MFG_LOOKUPS MLU_BIT '||
1783: ' WHERE 1=1 '||
1784: ' AND BICO.REVISED_ITEM_SEQUENCE_ID = ERI.REVISED_ITEM_SEQUENCE_ID '||