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_HOLDS_PVT dependencies on OE_ORDER_SOURCES

Line 1567: oe_order_sources oos

1563: FROM oe_order_holds ooh,
1564: oe_hold_sources ohs,
1565: oe_hold_definitions ohd,
1566: oe_order_headers_all h,
1567: oe_order_sources oos
1568: WHERE ooh.header_id = h.header_id
1569: -- AND ohd.activity_name IS NULL Bug 6791587
1570: AND oos.aia_enabled_flag = 'Y'
1571: AND ohd.hold_id = ohs.hold_id

Line 2848: oe_order_sources oos

2844: FROM oe_order_holds ooh,
2845: oe_hold_sources ohs,
2846: oe_hold_definitions ohd,
2847: oe_order_headers_all h,
2848: oe_order_sources oos
2849: WHERE ohd.activity_name IS NULL
2850: AND ohd.hold_id = ohs.hold_id
2851: AND ooh.header_id = h.header_id
2852: AND h.order_source_id = oos.order_source_id

Line 2865: oe_order_sources oos

2861: FROM oe_order_holds ooh,
2862: oe_hold_sources ohs,
2863: oe_hold_definitions ohd,
2864: oe_order_headers_all h,
2865: oe_order_sources oos
2866: WHERE ohd.activity_name IS NULL
2867: AND ohd.hold_id = ohs.hold_id
2868: AND h.order_source_id = oos.order_source_id
2869: AND oos.aia_enabled_flag = 'Y'

Line 8070: oe_order_sources oos

8066: FROM oe_order_holds ooh,
8067: oe_hold_sources ohs,
8068: oe_hold_definitions ohd,
8069: oe_order_headers_all h,
8070: oe_order_sources oos
8071: WHERE ohd.hold_id = ohs.hold_id
8072: -- AND ohd.activity_name IS NULL Bug 6791587
8073: AND ooh.header_id = h.header_id
8074: AND h.order_source_id = oos.order_source_id

Line 8087: oe_order_sources oos

8083: FROM oe_order_holds ooh,
8084: oe_hold_sources ohs,
8085: oe_hold_definitions ohd,
8086: oe_order_headers_all h,
8087: oe_order_sources oos
8088: WHERE ohd.hold_id = ohs.hold_id
8089: -- AND ohd.activity_name IS NULL Bug 6791587
8090: AND h.order_source_id = oos.order_source_id
8091: AND oos.aia_enabled_flag = 'Y'

Line 8116: oe_order_sources oos

8112: FROM oe_order_holds_all ooh,
8113: oe_hold_sources_all ohs,
8114: oe_hold_definitions ohd,
8115: oe_order_headers_all h,
8116: oe_order_sources oos
8117: WHERE ohd.hold_id = ohs.hold_id
8118: AND ooh.header_id = h.header_id
8119: AND ooh.org_id = p_org_id
8120: AND ooh.org_id = ohs.org_id

Line 8135: oe_order_sources oos

8131: FROM oe_order_holds_all ooh,
8132: oe_hold_sources_all ohs,
8133: oe_hold_definitions ohd,
8134: oe_order_headers_all h,
8135: oe_order_sources oos
8136: WHERE ohd.hold_id = ohs.hold_id
8137: AND ooh.org_id = p_org_id
8138: AND ooh.org_id = ohs.org_id
8139: AND ooh.org_id = h.org_id