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.OE_ORDER_WF_UTIL dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 45: FROM oe_workflow_assignments wf_assign,

41: trunc(sysdate) <= nvl(wf_assign.end_date_active, sysdate) to fix bug 3108864 */
42: CURSOR find_hdrprocessname (itemkey VARCHAR2)
43: IS
44: SELECT wf_assign.process_name
45: FROM oe_workflow_assignments wf_assign,
46: oe_order_headers_all header
47: WHERE header.header_id = TO_NUMBER (itemkey)
48: AND header.order_type_id = wf_assign.order_type_id
49: AND SYSDATE >= wf_assign.start_date_active

Line 59: FROM oe_workflow_assignments wf_assign,

55: /* NEED UPGRADE ON NEW COLUMN? */
56: CURSOR find_lineprocessname
57: IS
58: SELECT wf_assign.process_name
59: FROM oe_workflow_assignments wf_assign,
60: oe_order_headers_all header
61: WHERE NVL (p_wfasgn_item_type, '-99') =
62: NVL (wf_assign.item_type_code,
63: NVL (p_wfasgn_item_type, '-99')

Line 76: FROM oe_workflow_assignments wf_assign,

72:
73: CURSOR find_negotiatehdrprocessname (itemkey VARCHAR2)
74: IS
75: SELECT wf_assign.process_name
76: FROM oe_workflow_assignments wf_assign,
77: oe_order_headers_all header
78: WHERE header.header_id = TO_NUMBER (itemkey)
79: AND header.order_type_id = wf_assign.order_type_id
80: AND SYSDATE >= wf_assign.start_date_active

Line 88: FROM oe_workflow_assignments wf_assign,

84:
85: CURSOR find_bktngohdrprocessname (itemkey VARCHAR2)
86: IS
87: SELECT wf_assign.process_name
88: FROM oe_workflow_assignments wf_assign,
89: oe_blanket_headers_all header
90: WHERE header.header_id = TO_NUMBER (itemkey)
91: AND header.order_type_id = wf_assign.order_type_id
92: AND SYSDATE >= wf_assign.start_date_active

Line 100: FROM oe_workflow_assignments wf_assign,

96:
97: CURSOR find_blankethdrprocessname (itemkey VARCHAR2)
98: IS
99: SELECT wf_assign.process_name
100: FROM oe_workflow_assignments wf_assign,
101: oe_blanket_headers_all blanket
102: WHERE blanket.header_id = TO_NUMBER (itemkey)
103: AND blanket.order_type_id = wf_assign.order_type_id
104: AND SYSDATE >= wf_assign.start_date_active