APPS.BOM_DIAGUNITTEST_ECODATA dependencies on ENG_ENGINEERING_CHANGES

Line 99: from eng_engineering_changes

95: Begin
96: Select 1 into l_eco_exists
97: from dual
98: where exists (select 1
99: from eng_engineering_changes
100: where change_notice=l_eco_name
101: and organization_id=nvl(l_org_id,organization_id));
102: Exception
103: When no_data_found then

Line 237: ' FROM eng_engineering_changes eec '||

233: ' ,EEC.PLM_OR_ERP_CHANGE "PLM OR ERP CHANGE" '||
234: ' ,to_char(EEC.EXPIRATION_DATE,''DD-MON-YYYY HH24:MI:SS'') "EXPIRATION DATE" '||
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 '||

Line 1359: ' from eng_engineering_changes_v eecv, '||

1355: ' EEAV.SEQUENCE2 "SEQUENCE2", '||
1356: ' EEAV.DESCRIPTION "DESCRIPTION (Approver)", '||
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 '||

Line 1404: ' from eng_engineering_changes_v eecv, '||

1400: ' ,to_char(WFR.START_DATE,''DD-MON-YYYY HH24:MI:SS'') "START DATE" '||
1401: ' ,WFR.STATUS "STATUS" '||
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 '||

Line 1450: ' from eng_engineering_changes_v eecv, '||

1446: ' ,to_char(WFU.START_DATE,''DD-MON-YYYY HH24:MI:SS'')"START DATE" '||
1447: ' ,WFU.STATUS "STATUS" '||
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 '||

Line 1492: ' eng_engineering_changes_v eecv, '||

1488: ' ,to_char(WFUR.EXPIRATION_DATE,''DD-MON-YYYY HH24:MI:SS'') "EXPIRATION DATE"'||
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'' '||

Line 1535: ' ,ENG_ENGINEERING_CHANGES EEC '||

1531: ' ,OSE.POSITION_CONTROL_ENABLED_FLAG "Position Control Enabled Flag" '||
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 '||