APPS.OE_HOLDS_PVT dependencies on OE_ORDER_SOURCES

Line 1881: oe_order_sources oos

1877: FROM oe_order_holds ooh,
1878: oe_hold_sources ohs,
1879: oe_hold_definitions ohd,
1880: oe_order_headers_all h,
1881: oe_order_sources oos
1882: WHERE ooh.header_id = h.header_id
1883: -- AND ohd.activity_name IS NULL Bug 6791587
1884: AND oos.aia_enabled_flag = 'Y'
1885: AND ohd.hold_id = ohs.hold_id

Line 1903: oe_order_sources src

1899: select ohld.header_id,
1900: ohld.line_id
1901: from oe_order_holds ohld,
1902: oe_order_headers ooh,
1903: oe_order_sources src
1904: where ohld.order_hold_id = p_ord_hld_id
1905: and ohld.header_id = ooh.header_id
1906: and src.order_source_id = ooh.order_source_id
1907: and src.aia_enabled_flag = 'Y';

Line 3303: oe_order_sources oos

3299: FROM oe_order_holds ooh,
3300: oe_hold_sources ohs,
3301: oe_hold_definitions ohd,
3302: oe_order_headers_all h,
3303: oe_order_sources oos
3304: WHERE ohd.activity_name IS NULL
3305: AND ohd.hold_id = ohs.hold_id
3306: AND ooh.header_id = h.header_id
3307: AND h.order_source_id = oos.order_source_id

Line 3320: oe_order_sources oos

3316: FROM oe_order_holds ooh,
3317: oe_hold_sources ohs,
3318: oe_hold_definitions ohd,
3319: oe_order_headers_all h,
3320: oe_order_sources oos
3321: WHERE ohd.activity_name IS NULL
3322: AND ohd.hold_id = ohs.hold_id
3323: AND h.order_source_id = oos.order_source_id
3324: AND oos.aia_enabled_flag = 'Y'

Line 5265: oe_order_sources src

5261: select ohld.header_id,
5262: ohld.line_id
5263: from oe_order_holds ohld,
5264: oe_order_headers ooh,
5265: oe_order_sources src
5266: where ohld.order_hold_id = p_ord_hld_id
5267: and ohld.header_id = ooh.header_id
5268: and src.order_source_id = ooh.order_source_id
5269: and src.aia_enabled_flag = 'Y';

Line 8926: oe_order_sources oos

8922: FROM oe_order_holds ooh,
8923: oe_hold_sources ohs,
8924: oe_hold_definitions ohd,
8925: oe_order_headers_all h,
8926: oe_order_sources oos
8927: WHERE ohd.hold_id = ohs.hold_id
8928: -- AND ohd.activity_name IS NULL Bug 6791587
8929: AND ooh.header_id = h.header_id
8930: AND h.order_source_id = oos.order_source_id

Line 8943: oe_order_sources oos

8939: FROM oe_order_holds ooh,
8940: oe_hold_sources ohs,
8941: oe_hold_definitions ohd,
8942: oe_order_headers_all h,
8943: oe_order_sources oos
8944: WHERE ohd.hold_id = ohs.hold_id
8945: -- AND ohd.activity_name IS NULL Bug 6791587
8946: AND h.order_source_id = oos.order_source_id
8947: AND oos.aia_enabled_flag = 'Y'

Line 8972: oe_order_sources oos

8968: FROM oe_order_holds_all ooh,
8969: oe_hold_sources_all ohs,
8970: oe_hold_definitions ohd,
8971: oe_order_headers_all h,
8972: oe_order_sources oos
8973: WHERE ohd.hold_id = ohs.hold_id
8974: AND ooh.header_id = h.header_id
8975: AND ooh.org_id = p_org_id
8976: AND ooh.org_id = ohs.org_id

Line 8991: oe_order_sources oos

8987: FROM oe_order_holds_all ooh,
8988: oe_hold_sources_all ohs,
8989: oe_hold_definitions ohd,
8990: oe_order_headers_all h,
8991: oe_order_sources oos
8992: WHERE ohd.hold_id = ohs.hold_id
8993: AND ooh.org_id = p_org_id
8994: AND ooh.org_id = ohs.org_id
8995: AND ooh.org_id = h.org_id