DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on OE_ORDER_HOLDS_ALL

Line 6326: FROM oe_order_holds_all oeh ,

6322: AND NVL(oh.booked_flag,'N') = 'N'
6323: AND EXISTS
6324: (
6325: SELECT 'x'
6326: FROM oe_order_holds_all oeh ,
6327: oe_hold_sources_all ohs,
6328: oe_hold_definitions od
6329: WHERE oeh.header_id = oh.header_id
6330: AND NVL(oeh.released_flag,'N') <> 'Y'

Line 6353: FROM oe_order_holds_all oeh ,

6349: WHERE oh.header_id = p_order_header_id
6350: AND EXISTS
6351: (
6352: SELECT 'x'
6353: FROM oe_order_holds_all oeh ,
6354: oe_hold_sources_all ohs,
6355: oe_hold_definitions od
6356: WHERE oeh.header_id = oh.header_id
6357: AND NVL(oeh.released_flag,'N') <> 'Y'

Line 6372: FROM oe_order_holds_all oeh ,

6368: WHERE oh.header_id = p_order_header_id
6369: AND EXISTS
6370: (
6371: SELECT 'x'
6372: FROM oe_order_holds_all oeh ,
6373: oe_hold_sources_all ohs,
6374: oe_hold_definitions od
6375: WHERE oeh.header_id = oh.header_id
6376: AND NVL(oeh.released_flag,'N') <> 'Y'