APPS.ONT_OIP_COMMON dependencies on OE_ORDER_HOLDS_ALL

Line 28: oe_order_holds_all hold,

24: IS
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

Line 43: oe_order_holds_all hold,

39: IS
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