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.ENG_WORKFLOW_UTIL dependencies on ENG_CHANGE_ROUTES

Line 2278: ENG_CHANGE_ROUTES Route,

2274: CURSOR c_wfsigpolicy ( p_route_id NUMBER )
2275: IS
2276: SELECT TempLCStatus.WF_SIG_POLICY
2277: FROM ENG_LIFECYCLE_STATUSES TempLCStatus,
2278: ENG_CHANGE_ROUTES Route,
2279: ENG_ENGINEERING_CHANGES EngChange
2280: WHERE TempLCStatus.ENTITY_NAME = 'ENG_CHANGE_TYPE'
2281: AND TempLCStatus.ENTITY_ID1 = EngChange.CHANGE_ORDER_TYPE_ID
2282: AND TO_CHAR(TempLCStatus.STATUS_CODE) = Route.CLASSIFICATION_CODE

Line 2741: FROM ENG_CHANGE_ROUTES

2737:
2738: CURSOR c_route (p_route_id NUMBER)
2739: IS
2740: SELECT ROUTE_TYPE_CODE
2741: FROM ENG_CHANGE_ROUTES
2742: WHERE ROUTE_ID = p_route_id ;
2743:
2744: BEGIN
2745:

Line 3639: ENG_CHANGE_ROUTES line_wf,

3635: , l_route_type_code
3636: FROM FND_LOOKUPS dist_stat_flu,
3637: FND_LOOKUPS flu,
3638: MFG_LOOKUPS mlu,
3639: ENG_CHANGE_ROUTES line_wf,
3640: ENG_CHANGE_LINES_VL ecl
3641: WHERE line_wf.route_id (+)= ecl.route_id
3642: AND dist_stat_flu.lookup_code (+)= ecl.status_code
3643: AND dist_stat_flu.lookup_type (+)= 'ENG_DIST_LINE_STATUSES'

Line 4279: -- , ENG_CHANGE_ROUTES ecr

4275: CURSOR c_lines (p_change_id NUMBER)
4276: IS
4277: SELECT ecl.change_line_id
4278: FROM ENG_CHANGE_LINES ecl
4279: -- , ENG_CHANGE_ROUTES ecr
4280: WHERE ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
4281: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )
4282: -- AND ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
4283: -- AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )

Line 4431: update ENG_CHANGE_ROUTES set

4427: Write_Debug('Updating Route Table ... Route Id: ' || to_Char(p_route_id) );
4428: END IF ;
4429:
4430:
4431: update ENG_CHANGE_ROUTES set
4432: OWNER_ID = DECODE(l_set_start_date_flag, 1, p_wf_user_id, OWNER_ID) ,
4433: WF_ITEM_TYPE = p_item_type ,
4434: WF_ITEM_KEY = p_item_key,
4435: STATUS_CODE = p_new_status_code ,

Line 5828: FROM ENG_CHANGE_ROUTES

5824: CURSOR c_route_status (p_route_id NUMBER)
5825: IS
5826:
5827: SELECT 'Can not be started'
5828: FROM ENG_CHANGE_ROUTES
5829: WHERE route_id = p_route_id
5830: AND status_code <> Eng_Workflow_Util.G_RT_NOT_STARTED ;
5831:
5832: CURSOR c_route_instance (p_route_id NUMBER)

Line 5836: FROM ENG_CHANGE_ROUTES

5832: CURSOR c_route_instance (p_route_id NUMBER)
5833: IS
5834:
5835: SELECT 'Can not be started'
5836: FROM ENG_CHANGE_ROUTES
5837: WHERE route_id = p_route_id
5838: AND template_flag <> Eng_Workflow_Util.G_RT_INSTANCE ;
5839:
5840:

Line 7779: FROM ENG_CHANGE_ROUTES

7775: SELECT STATUS_CODE
7776: , CLASSIFICATION_CODE
7777: , OBJECT_NAME
7778: , OBJECT_ID1
7779: FROM ENG_CHANGE_ROUTES
7780: WHERE ROUTE_ID = p_route_id
7781: AND TEMPLATE_FLAG = Eng_Workflow_Util.G_RT_INSTANCE ;
7782:
7783: BEGIN

Line 7932: FROM ENG_CHANGE_ROUTES

7928: SELECT STATUS_CODE
7929: , CLASSIFICATION_CODE
7930: , OBJECT_NAME
7931: , OBJECT_ID1
7932: FROM ENG_CHANGE_ROUTES
7933: WHERE ROUTE_ID = p_route_id
7934: AND TEMPLATE_FLAG = Eng_Workflow_Util.G_RT_INSTANCE ;
7935:
7936: BEGIN

Line 8088: , ENG_CHANGE_ROUTES ecr

8084: IS
8085: SELECT wi.item_type
8086: , wi.item_key
8087: FROM ENG_ENGINEERING_CHANGES eec
8088: , ENG_CHANGE_ROUTES ecr
8089: , WF_ITEMS wi
8090: WHERE wi.end_date IS NULL
8091: AND wi.item_key = ecr.wf_item_key
8092: AND wi.item_type = ecr.wf_item_type

Line 8104: , ENG_CHANGE_ROUTES ecr

8100: IS
8101: SELECT wi.item_type
8102: , wi.item_key
8103: FROM ENG_CHANGE_LINES ecl
8104: , ENG_CHANGE_ROUTES ecr
8105: , WF_ITEMS wi
8106: WHERE wi.end_date IS NULL
8107: AND wi.item_key = ecr.wf_item_key
8108: AND wi.item_type = ecr.wf_item_type

Line 9175: , ENG_CHANGE_ROUTES ecr

9171: , ecl.route_id
9172: , ecr.wf_item_type
9173: , ecr.wf_process_name
9174: FROM ENG_CHANGE_LINES ecl
9175: , ENG_CHANGE_ROUTES ecr
9176: WHERE ( ecl.status_code <> Eng_Workflow_Util.G_CL_COMPLETED
9177: AND ecl.status_code <> Eng_Workflow_Util.G_CL_CANCELLED )
9178: AND ( ecl.approval_status_type <> Eng_Workflow_Util.G_APPROVED
9179: AND ecl.approval_status_type <> Eng_Workflow_Util.G_REQUESTED )

Line 10463: FROM ENG_CHANGE_ROUTES ecr

10459: CURSOR c_header_route_wf (p_change_id NUMBER)
10460: IS
10461: SELECT ecr.wf_item_type parent_item_type
10462: , ecr.wf_item_key parent_item_key
10463: FROM ENG_CHANGE_ROUTES ecr
10464: , ENG_ENGINEERING_CHANGES eec
10465: , WF_ITEMS wi
10466: WHERE wi.item_type = ecr.wf_item_type
10467: AND wi.item_key = ecr.wf_item_key

Line 14268: FROM ENG_CHANGE_ROUTES routes

14264: IS
14265: SELECT routes.OBJECT_ID1 CHANGE_ID
14266: , TO_NUMBER(NULL) CHANGE_LINE_ID
14267: , routes.ROUTE_ID
14268: FROM ENG_CHANGE_ROUTES routes
14269: WHERE routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14270: , Eng_Workflow_Util.G_RT_APPROVED
14271: , Eng_Workflow_Util.G_RT_COMPLETED
14272: , Eng_Workflow_Util.G_RT_TIME_OUT) -- G_RT_ABORTED was taken care by ABORT WF

Line 14284: FROM ENG_CHANGE_ROUTES line_routes

14280: IS
14281: SELECT chg_line.CHANGE_ID
14282: , chg_line.CHANGE_LINE_ID
14283: , line_routes.ROUTE_ID
14284: FROM ENG_CHANGE_ROUTES line_routes
14285: , ENG_CHANGE_LINES chg_line
14286: WHERE line_routes.STATUS_CODE IN ( Eng_Workflow_Util.G_RT_REJECTED
14287: , Eng_Workflow_Util.G_RT_APPROVED
14288: , Eng_Workflow_Util.G_RT_COMPLETED