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.

[Home] [Help]

APPS.ENG_DEFAULT_ECO dependencies on ENG_CHANGE_PRIORITIES

Line 165: ENG_CHANGE_PRIORITIES WHERE

161: )is
162: SELECT TypePriorityCodeEO.PRIORITY_CODE
163: FROM
164: ENG_CHANGE_TYPE_PRIORITIES TypePriorityCodeEO,
165: ENG_CHANGE_PRIORITIES WHERE
166: TypePriorityCodeEO.CHANGE_TYPE_ID = p_change_order_type_id AND
167: TypePriorityCodeEO.PRIORITY_CODE = ENG_CHANGE_PRIORITIES.ENG_CHANGE_PRIORITY_CODE
168: AND ENG_CHANGE_PRIORITIES.ORGANIZATION_ID=-1
169: AND ROWNUM=1

Line 167: TypePriorityCodeEO.PRIORITY_CODE = ENG_CHANGE_PRIORITIES.ENG_CHANGE_PRIORITY_CODE

163: FROM
164: ENG_CHANGE_TYPE_PRIORITIES TypePriorityCodeEO,
165: ENG_CHANGE_PRIORITIES WHERE
166: TypePriorityCodeEO.CHANGE_TYPE_ID = p_change_order_type_id AND
167: TypePriorityCodeEO.PRIORITY_CODE = ENG_CHANGE_PRIORITIES.ENG_CHANGE_PRIORITY_CODE
168: AND ENG_CHANGE_PRIORITIES.ORGANIZATION_ID=-1
169: AND ROWNUM=1
170: ORDER BY ENG_CHANGE_PRIORITY_CODE;
171:

Line 168: AND ENG_CHANGE_PRIORITIES.ORGANIZATION_ID=-1

164: ENG_CHANGE_TYPE_PRIORITIES TypePriorityCodeEO,
165: ENG_CHANGE_PRIORITIES WHERE
166: TypePriorityCodeEO.CHANGE_TYPE_ID = p_change_order_type_id AND
167: TypePriorityCodeEO.PRIORITY_CODE = ENG_CHANGE_PRIORITIES.ENG_CHANGE_PRIORITY_CODE
168: AND ENG_CHANGE_PRIORITIES.ORGANIZATION_ID=-1
169: AND ROWNUM=1
170: ORDER BY ENG_CHANGE_PRIORITY_CODE;
171:
172: --Bug 13721297 set default value for assignee