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.CSD_PROCESS_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 6118: oe_order_headers_all ooh,

6114: Select max(ced.order_header_id)
6115: into l_add_to_order_id
6116: from csd_repairs dr,
6117: cs_estimate_details ced,
6118: oe_order_headers_all ooh,
6119: oe_order_types_v oot,
6120: cs_incidents_all_b sr -- swai: bug 5931926
6121: where dr.repair_line_id = p_repair_line_id
6122: and ced.incident_id = dr.incident_id

Line 6153: oe_order_headers_all ooh,

6149: Select max(ced.order_header_id)
6150: into l_add_to_order_id
6151: from csd_repairs dr,
6152: cs_estimate_details ced,
6153: oe_order_headers_all ooh,
6154: oe_order_types_v oot,
6155: cs_incidents_all_b sr -- swai: bug 5931926
6156: where dr.repair_line_id = p_repair_line_id
6157: and ced.incident_id = dr.incident_id

Line 6320: FROM oe_order_headers_all oh

6316: -- cannot happen, and hence autoreceiving will fail.
6317: BEGIN
6318: SELECT 'Y'
6319: INTO l_order_hold
6320: FROM oe_order_headers_all oh
6321: WHERE oh.header_id = p_order_header_id
6322: AND NVL(oh.booked_flag,'N') = 'N'
6323: AND EXISTS
6324: (

Line 6348: FROM oe_order_headers_all oh

6344: SELECT holdexists
6345: INTO l_order_hold
6346: FROM (
6347: SELECT 'Y' holdexists
6348: FROM oe_order_headers_all oh
6349: WHERE oh.header_id = p_order_header_id
6350: AND EXISTS
6351: (
6352: SELECT 'x'

Line 6367: FROM oe_order_headers_all oh

6363:
6364: union all
6365:
6366: SELECT 'Y' holdexists
6367: FROM oe_order_headers_all oh
6368: WHERE oh.header_id = p_order_header_id
6369: AND EXISTS
6370: (
6371: SELECT 'x'