eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_HOLDS_PUB dependencies on OE_HOLD_DEFINITIONS

Line 552: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

548: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
549: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
550: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
551: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
552: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
553: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
554: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
555: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
556: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 792: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

788: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
789: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
790: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
791: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
792: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
793: DEFAULT NULL,
794: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
795: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
796: DEFAULT NULL,

Line 1252: oe_hold_definitions h

1248: and oh.hold_release_id is null
1249: AND EXISTS
1250: (SELECT 1
1251: FROM oe_hold_sources_all hs,
1252: oe_hold_definitions h
1253: WHERE oh.hold_source_id = hs.hold_source_id
1254: AND hs.hold_id = h.hold_id
1255: AND NVL(h.item_type,
1256: DECODE(p_chk_act_hold_only,

Line 1382: oe_hold_definitions h

1378: and oh.hold_release_id is null
1379: AND EXISTS
1380: (SELECT 1
1381: FROM oe_hold_sources_all hs,
1382: oe_hold_definitions h
1383: WHERE oh.hold_source_id = hs.hold_source_id
1384: AND hs.hold_id = h.hold_id
1385: AND NVL(h.item_type,
1386: DECODE(p_chk_act_hold_only,

Line 1508: oe_hold_definitions h

1504: and oh.hold_release_id is null
1505: AND EXISTS
1506: (SELECT 1
1507: FROM oe_hold_sources_all hs,
1508: oe_hold_definitions h
1509: WHERE oh.hold_source_id = hs.hold_source_id
1510: AND hs.hold_id = h.hold_id
1511: AND NVL(h.item_type,
1512: DECODE(p_chk_act_hold_only,

Line 1616: oe_hold_definitions h

1612: and ROWNUM = 1
1613: AND EXISTS
1614: (SELECT 1
1615: FROM oe_hold_sources_all hs,
1616: oe_hold_definitions h
1617: WHERE oh.hold_source_id = hs.hold_source_id
1618: AND hs.hold_id = h.hold_id
1619: AND NVL(h.item_type,
1620: DECODE(x_hold_rec.p_chk_act_hold_only,

Line 1830: oe_hold_definitions h

1826: AND oh.hold_release_id IS NULL
1827: AND EXISTS
1828: (SELECT 1
1829: FROM oe_hold_sources_all hs,
1830: oe_hold_definitions h
1831: WHERE oh.hold_source_id = hs.hold_source_id
1832: AND hs.hold_id = h.hold_id
1833: AND NVL(h.item_type,
1834: DECODE(p_chk_act_hold_only,

Line 2281: oe_hold_definitions h

2277:
2278: SELECT 'ANY_HOLD_SOURCE'
2279: INTO l_dummy
2280: FROM oe_hold_sources_all hs,
2281: oe_hold_definitions h
2282: WHERE hs.hold_id = h.hold_id
2283: AND NVL(h.item_type,
2284: DECODE(p_chk_act_hold_only,
2285: 'Y', 'XXXXX',

Line 2942: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

2938: CURSOR curr_hold_source IS
2939: SELECT HS.hold_source_id, hs.hold_id,
2940: hs.hold_entity_code, hs.hold_entity_id,
2941: hs.hold_entity_code2,hs.hold_entity_id2
2942: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
2943: WHERE HS.HOLD_ENTITY_CODE = p_hold_entity_code
2944: AND HS.HOLD_ENTITY_ID = p_hold_entity_id
2945: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
2946: ROUND( SYSDATE )

Line 2957: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

2953: CURSOR curr_hold_source_entity2 IS
2954: SELECT HS.hold_source_id, hs.hold_id,
2955: hs.hold_entity_code, hs.hold_entity_id,
2956: hs.hold_entity_code2,hs.hold_entity_id2
2957: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
2958: WHERE HS.HOLD_ENTITY_CODE2 = p_hold_entity_code
2959: AND HS.HOLD_ENTITY_ID2 = p_hold_entity_id
2960: AND HS.HOLD_ENTITY_CODE <> 'O'
2961: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=

Line 4001: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

3997: --ER#7479609 p_hold_entity_id NUMBER) IS
3998: SELECT HS.hold_source_id, hs.hold_id,
3999: hs.hold_entity_code, hs.hold_entity_id,
4000: hs.hold_entity_code2,hs.hold_entity_id2
4001: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4002: WHERE HLD.HOLD_ID = HS.HOLD_ID
4003: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4004: ROUND( SYSDATE )
4005: AND HS.RELEASED_FLAG = 'N'

Line 4210: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4206: --ER#7479609 p_hold_entity_id NUMBER) IS
4207: SELECT HS.hold_source_id, hs.hold_id,
4208: hs.hold_entity_code, hs.hold_entity_id,
4209: hs.hold_entity_code2,hs.hold_entity_id2
4210: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4211: WHERE HLD.HOLD_ID = HS.HOLD_ID
4212: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4213: ROUND( SYSDATE )
4214: AND HS.RELEASED_FLAG = 'N'

Line 4253: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4249: p_hold_entity_id2 NUMBER) IS
4250: SELECT HS.hold_source_id, hs.hold_id,
4251: hs.hold_entity_code, hs.hold_entity_id,
4252: hs.hold_entity_code2,hs.hold_entity_id2
4253: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4254: WHERE HLD.HOLD_ID = HS.HOLD_ID
4255: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4256: ROUND( SYSDATE )
4257: AND HS.RELEASED_FLAG = 'N'