DBA Data[Home] [Help]

APPS.ONT_OIP_COMMON dependencies on OE_HOLD_SOURCES_ALL

Line 29: oe_hold_sources_all src,

25: select distinct def.name hold_name,
26: def.hold_id
27: from oe_order_headers_all h,
28: oe_order_holds_all hold,
29: oe_hold_sources_all src,
30: oe_hold_definitions def
31: where h.header_id=hold.header_id
32: and hold.hold_source_id=src.hold_source_id
33: and hold.line_id IS NULL

Line 44: oe_hold_sources_all src,

40: select distinct def.name hold_name,
41: def.hold_id
42: from oe_order_lines_all l,
43: oe_order_holds_all hold,
44: oe_hold_sources_all src,
45: oe_hold_definitions def
46: where hold.header_id=l.header_id
47: and hold.line_id=l.line_id
48: and hold.hold_source_id=src.hold_source_id