DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on OE_HOLD_SOURCES_ALL

Line 6327: oe_hold_sources_all ohs,

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'
6331: AND oeh.line_id IS NULL

Line 6354: oe_hold_sources_all ohs,

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'
6358: AND oeh.line_id IS NULL

Line 6373: oe_hold_sources_all ohs,

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'
6377: AND oeh.line_id = p_order_line_id