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 622: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,

618: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
619: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
620: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
621: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
622: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE,
623: p_hold_until_date IN OE_HOLD_SOURCES.HOLD_UNTIL_DATE%TYPE DEFAULT NULL,
624: p_hold_comment IN OE_HOLD_SOURCES.HOLD_COMMENT%TYPE DEFAULT NULL,
625: p_check_authorization_flag IN VARCHAR2 DEFAULT 'N', -- bug 8477694
626: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 875: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE

871: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
872: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
873: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
874: p_order_tbl IN OE_HOLDS_PVT.order_tbl_type,
875: p_hold_id IN OE_HOLD_DEFINITIONS.HOLD_ID%TYPE
876: DEFAULT NULL,
877: p_release_reason_code IN OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE,
878: p_release_comment IN OE_HOLD_RELEASES.RELEASE_COMMENT%TYPE
879: DEFAULT NULL,

Line 1341: oe_hold_definitions h

1337: and oh.hold_release_id is null
1338: AND EXISTS
1339: (SELECT 1
1340: FROM oe_hold_sources_all hs,
1341: oe_hold_definitions h
1342: WHERE oh.hold_source_id = hs.hold_source_id
1343: AND hs.hold_id = h.hold_id
1344: AND NVL(h.item_type,
1345: DECODE(p_chk_act_hold_only,

Line 1471: oe_hold_definitions h

1467: and oh.hold_release_id is null
1468: AND EXISTS
1469: (SELECT 1
1470: FROM oe_hold_sources_all hs,
1471: oe_hold_definitions h
1472: WHERE oh.hold_source_id = hs.hold_source_id
1473: AND hs.hold_id = h.hold_id
1474: AND NVL(h.item_type,
1475: DECODE(p_chk_act_hold_only,

Line 1597: oe_hold_definitions h

1593: and oh.hold_release_id is null
1594: AND EXISTS
1595: (SELECT 1
1596: FROM oe_hold_sources_all hs,
1597: oe_hold_definitions h
1598: WHERE oh.hold_source_id = hs.hold_source_id
1599: AND hs.hold_id = h.hold_id
1600: AND NVL(h.item_type,
1601: DECODE(p_chk_act_hold_only,

Line 1705: oe_hold_definitions h

1701: and ROWNUM = 1
1702: AND EXISTS
1703: (SELECT 1
1704: FROM oe_hold_sources_all hs,
1705: oe_hold_definitions h
1706: WHERE oh.hold_source_id = hs.hold_source_id
1707: AND hs.hold_id = h.hold_id
1708: AND NVL(h.item_type,
1709: DECODE(x_hold_rec.p_chk_act_hold_only,

Line 1919: oe_hold_definitions h

1915: AND oh.hold_release_id IS NULL
1916: AND EXISTS
1917: (SELECT 1
1918: FROM oe_hold_sources_all hs,
1919: oe_hold_definitions h
1920: WHERE oh.hold_source_id = hs.hold_source_id
1921: AND hs.hold_id = h.hold_id
1922: AND NVL(h.item_type,
1923: DECODE(p_chk_act_hold_only,

Line 2370: oe_hold_definitions h

2366:
2367: SELECT 'ANY_HOLD_SOURCE'
2368: INTO l_dummy
2369: FROM oe_hold_sources_all hs,
2370: oe_hold_definitions h
2371: WHERE hs.hold_id = h.hold_id
2372: AND NVL(h.item_type,
2373: DECODE(p_chk_act_hold_only,
2374: 'Y', 'XXXXX',

Line 3044: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

3040: CURSOR curr_hold_source IS
3041: SELECT HS.hold_source_id, hs.hold_id,
3042: hs.hold_entity_code, hs.hold_entity_id,
3043: hs.hold_entity_code2,hs.hold_entity_id2
3044: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
3045: --WHERE HS.HOLD_ENTITY_CODE = p_hold_entity_code -- ER#3667551
3046: WHERE HS.HOLD_ENTITY_CODE = NVL(l_bth_entity_code,p_hold_entity_code) -- ER#3667551
3047: AND HS.HOLD_ID = NVL(l_bth_hold_id,HS.HOLD_ID) -- ER#3667551
3048: AND HS.HOLD_ENTITY_ID = p_hold_entity_id

Line 3061: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

3057: CURSOR curr_hold_source_entity2 IS
3058: SELECT HS.hold_source_id, hs.hold_id,
3059: hs.hold_entity_code, hs.hold_entity_id,
3060: hs.hold_entity_code2,hs.hold_entity_id2
3061: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
3062: --WHERE HS.HOLD_ENTITY_CODE2 = p_hold_entity_code -- ER#3667551
3063: WHERE HS.HOLD_ENTITY_CODE2 = NVL(l_bth_entity_code,p_hold_entity_code) -- ER#3667551
3064: AND HS.HOLD_ID = NVL(l_bth_hold_id,HS.HOLD_ID) -- ER#3667551
3065: AND HS.HOLD_ENTITY_ID2 = p_hold_entity_id

Line 4259: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4255: --ER#7479609 p_hold_entity_id NUMBER) IS
4256: SELECT HS.hold_source_id, hs.hold_id,
4257: hs.hold_entity_code, hs.hold_entity_id,
4258: hs.hold_entity_code2,hs.hold_entity_id2
4259: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4260: WHERE HLD.HOLD_ID = HS.HOLD_ID
4261: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4262: ROUND( SYSDATE )
4263: AND HS.RELEASED_FLAG = 'N'

Line 4469: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4465: --ER#7479609 p_hold_entity_id NUMBER) IS
4466: SELECT HS.hold_source_id, hs.hold_id,
4467: hs.hold_entity_code, hs.hold_entity_id,
4468: hs.hold_entity_code2,hs.hold_entity_id2
4469: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4470: WHERE HLD.HOLD_ID = HS.HOLD_ID
4471: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4472: ROUND( SYSDATE )
4473: AND HS.RELEASED_FLAG = 'N'

Line 4493: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4489: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS
4490: SELECT HS.hold_source_id, hs.hold_id,
4491: hs.hold_entity_code, hs.hold_entity_id,
4492: hs.hold_entity_code2,hs.hold_entity_id2
4493: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4494: WHERE HLD.HOLD_ID = HS.HOLD_ID
4495: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4496: ROUND( SYSDATE )
4497: AND HS.RELEASED_FLAG = 'N'

Line 4510: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4506: p_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE) IS
4507: SELECT HS.hold_source_id, hs.hold_id,
4508: hs.hold_entity_code, hs.hold_entity_id,
4509: hs.hold_entity_code2,hs.hold_entity_id2
4510: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4511: WHERE HLD.HOLD_ID = HS.HOLD_ID
4512: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4513: ROUND( SYSDATE )
4514: AND HS.RELEASED_FLAG = 'N'

Line 4550: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD

4546: p_hold_entity_id2 NUMBER) IS
4547: SELECT HS.hold_source_id, hs.hold_id,
4548: hs.hold_entity_code, hs.hold_entity_id,
4549: hs.hold_entity_code2,hs.hold_entity_id2
4550: FROM OE_HOLD_SOURCES HS, OE_HOLD_definitions HLD
4551: WHERE HLD.HOLD_ID = HS.HOLD_ID
4552: AND ROUND( NVL(HS.HOLD_UNTIL_DATE, SYSDATE ) ) >=
4553: ROUND( SYSDATE )
4554: AND HS.RELEASED_FLAG = 'N'