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_PVT dependencies on OE_HOLD_SOURCES_ALL

Line 25: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE

21: /*
22: *
23: */
24: function entity_code_value (
25: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE
26: )
27: return VARCHAR2
28: IS
29: l_hold_entity_code_value VARCHAR2 (100) := NULL;

Line 119: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,

115: END get_user_id;
116:
117:
118: function entity_id_value (
119: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,
120: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )
121: return VARCHAR2
122: IS
123: l_hold_entity_id_value VARCHAR2 (100) := NULL;

Line 120: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )

116:
117:
118: function entity_id_value (
119: p_hold_entity_code IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE,
120: p_hold_entity_id IN OE_HOLD_SOURCES_ALL.HOLD_ENTITY_ID%TYPE )
121: return VARCHAR2
122: IS
123: l_hold_entity_id_value VARCHAR2 (100) := NULL;
124:

Line 394: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)

390:
391: END entity_id_value;
392: --------------------------
393: function hold_name(
394: p_hold_source_id IN OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE)
395: return varchar2
396: IS
397: l_hold_name oe_hold_definitions.name%type := '';
398: BEGIN

Line 1039: Procedure InsertTable_OOH_Header (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type

1035: -- p_activity_name : Workflow activity name
1036: -- p_activity_status : Workflow activity status
1037: -- p_additional_where_clause : Its derived from the p_item_type and p_activity_name
1038: ---------------------------------------------------------------------------------------------------
1039: Procedure InsertTable_OOH_Header (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type
1040: ,p_header_id OE_ORDER_HEADERS_ALL.header_id%type
1041: ,p_org_id OE_ORDER_HEADERS_ALL.org_id%type
1042: ,p_hold_entity_where_clause VARCHAR2
1043: ,p_item_type VARCHAR2

Line 1310: Procedure InsertTable_OOH_Line (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type,

1306: -- p_activity_name : Workflow activity name
1307: -- p_activity_status : Workflow activity status
1308: -- p_additional_where_clause : Its derived from the p_item_type and p_activity_name
1309: ---------------------------------------------------------------------------------------------------
1310: Procedure InsertTable_OOH_Line (p_hold_source_id OE_HOLD_SOURCES_ALL.hold_source_id%type,
1311: p_line_id OE_ORDER_LINES_ALL.line_id%type,
1312: p_org_id OE_ORDER_HEADERS_ALL.org_id%type,
1313: p_hold_entity_where_clause VARCHAR2,
1314: p_item_type VARCHAR2,

Line 2758: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,

2754: ---Overload procedure for bug5548778
2755: Procedure Create_Hold_Source (
2756: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
2757: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
2758: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
2759: x_hold_exists OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2760: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
2761: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2762: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)

Line 2768: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

2764: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_HOLD_SOURCE';
2765: l_user_id NUMBER;
2766: l_org_id NUMBER;
2767: l_count NUMBER;
2768: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
2769: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
2770: BEGIN
2771: x_return_status := FND_API.G_RET_STS_SUCCESS;
2772: x_hold_exists := 'N';

Line 2791: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

2787: IF p_hold_source_rec.line_id is not null THEN
2788: select count(*)
2789: into l_count
2790: --ER#7479609 FROM OE_HOLD_SOURCES HS
2791: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2792: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2793: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2794: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
2795: AND HS.HOLD_ENTITY_CODE2 is null

Line 2822: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

2818: ELSE
2819: select count(*)
2820: into l_count
2821: --ER#7479609 FROM OE_HOLD_SOURCES HS
2822: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2823: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2824: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2825: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
2826: AND HS.HOLD_ENTITY_CODE2 is null

Line 2854: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

2850: else
2851: select count(*)
2852: into l_count
2853: --ER#7479609 FROM OE_HOLD_SOURCES HS
2854: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
2855: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
2856: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
2857: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
2858: AND HS.org_id= p_org_id --ER#7479609

Line 2884: INSERT INTO OE_HOLD_SOURCES_ALL

2880: SELECT OE_HOLD_SOURCES_S.NEXTVAL
2881: INTO x_hold_source_id
2882: FROM DUAL;
2883:
2884: INSERT INTO OE_HOLD_SOURCES_ALL
2885: ( HOLD_SOURCE_ID
2886: , LAST_UPDATE_DATE
2887: , LAST_UPDATED_BY
2888: , CREATION_DATE

Line 3001: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,

2997: ------
2998: Procedure Create_Hold_Source (
2999: p_hold_source_rec IN OE_HOLDS_PVT.Hold_Source_Rec_Type,
3000: p_org_id IN NUMBER DEFAULT MO_GLOBAL.get_current_org_id, --ER#7479609
3001: x_hold_source_id OUT NOCOPY /* file.sql.39 change */ OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE,
3002: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
3003: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
3004: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
3005: IS

Line 3010: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

3006: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_HOLD_SOURCE';
3007: l_user_id NUMBER;
3008: l_org_id NUMBER;
3009: l_count NUMBER;
3010: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
3011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3012: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609
3013: BEGIN
3014: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3012: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609

3008: l_org_id NUMBER;
3009: l_count NUMBER;
3010: --l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
3011: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
3012: l_hold_comment OE_HOLD_SOURCES_ALL.HOLD_COMMENT%TYPE; --ER#7479609
3013: BEGIN
3014: x_return_status := FND_API.G_RET_STS_SUCCESS;
3015: l_user_id := OE_HOLDS_PVT.get_user_id;
3016: l_org_id := MO_GLOBAL.get_current_org_id;

Line 3033: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

3029: IF p_hold_source_rec.line_id is not null THEN
3030: select count(*)
3031: into l_count
3032: --ER#7479609 FROM OE_HOLD_SOURCES HS
3033: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3034: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3035: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3036: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
3037: AND HS.HOLD_ENTITY_CODE2 is null

Line 3062: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

3058: ELSE
3059: select count(*)
3060: into l_count
3061: --ER#7479609 FROM OE_HOLD_SOURCES HS
3062: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3063: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3064: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3065: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
3066: AND HS.HOLD_ENTITY_CODE2 is null

Line 3092: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609

3088: else
3089: select count(*)
3090: into l_count
3091: --ER#7479609 FROM OE_HOLD_SOURCES HS
3092: FROM OE_HOLD_SOURCES_ALL HS --ER#7479609
3093: WHERE HS.HOLD_ID = p_hold_source_rec.hold_id
3094: AND HS.HOLD_ENTITY_CODE = p_hold_source_rec.hold_entity_code
3095: AND HS.HOLD_ENTITY_ID = p_hold_source_rec.hold_entity_id
3096: AND nvl(HS.HOLD_ENTITY_CODE2, 'NO_ENTITY_CODE2') =

Line 3159: INSERT INTO OE_HOLD_SOURCES_ALL

3155: SELECT OE_HOLD_SOURCES_S.NEXTVAL
3156: INTO x_hold_source_id
3157: FROM DUAL;
3158:
3159: INSERT INTO OE_HOLD_SOURCES_ALL
3160: ( HOLD_SOURCE_ID
3161: , LAST_UPDATE_DATE
3162: , LAST_UPDATED_BY
3163: , CREATION_DATE

Line 5515: UPDATE oe_hold_sources_all --ER#7479609

5511: -- Flag the hold source as released
5512:
5513: oe_debug_pub.add('Updating oe_hold_sources for Release', 1);
5514: --ER#7479609 UPDATE oe_hold_sources
5515: UPDATE oe_hold_sources_all --ER#7479609
5516: SET hold_release_id = x_hold_release_id
5517: , released_flag = 'Y'
5518: , LAST_UPDATED_BY = l_user_id
5519: , LAST_UPDATE_DATE = sysdate

Line 5791: FROM OE_HOLD_SOURCES_all

5787: FROM OE_ORDER_HOLDS_all
5788: WHERE HEADER_ID = p_order_rec.header_id;
5789: CURSOR hold_source IS
5790: SELECT hold_source_id, NVL(hold_release_id,0)
5791: FROM OE_HOLD_SOURCES_all
5792: WHERE HOLD_ENTITY_CODE = 'O'
5793: AND HOLD_ENTITY_ID = p_order_rec.header_id;
5794: CURSOR line_hold IS
5795: SELECT order_hold_id, NVL(hold_release_id,0)

Line 5844: FROM OE_HOLD_SOURCES_all

5840: AND HOLD_RELEASE_ID NOT IN (SELECT NVL(HOLD_RELEASE_ID,0)
5841: FROM OE_ORDER_HOLDS_all
5842: UNION
5843: SELECT NVL(HOLD_RELEASE_ID,0)
5844: FROM OE_HOLD_SOURCES_all
5845: );
5846: END LOOP;
5847:
5848: CLOSE order_hold;

Line 5859: DELETE FROM OE_HOLD_SOURCES_all

5855: EXIT;
5856: END IF;
5857: OE_Debug_PUB.Add('Deleting hold source record',1);
5858:
5859: DELETE FROM OE_HOLD_SOURCES_all
5860: WHERE HOLD_SOURCE_ID = l_hold_source_id;
5861:
5862: OE_Debug_PUB.Add('Deleting hold release record',1);
5863: DELETE FROM OE_HOLD_RELEASES

Line 5870: FROM OE_HOLD_SOURCES_all

5866: ( SELECT NVL(HOLD_RELEASE_ID,0)
5867: FROM OE_ORDER_HOLDS_all
5868: UNION
5869: SELECT NVL(HOLD_RELEASE_ID,0)
5870: FROM OE_HOLD_SOURCES_all
5871: );
5872:
5873: END LOOP;
5874:

Line 5903: FROM OE_HOLD_SOURCES_all

5899: (SELECT NVL(HOLD_RELEASE_ID,0)
5900: FROM OE_ORDER_HOLDS_all
5901: UNION
5902: SELECT NVL(HOLD_RELEASE_ID,0)
5903: FROM OE_HOLD_SOURCES_all
5904: );
5905:
5906: END LOOP;
5907:

Line 5969: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

5965: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
5966: IS
5967: j NUMBER;
5968: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
5969: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
5970: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
5971: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
5972: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
5973: l_msg_token VARCHAR2(100); --8477694

Line 6232: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

6228: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
6229: IS
6230: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
6231: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
6232: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
6233: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
6234: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
6235: l_msg_token VARCHAR2(100); --8477694
6236: /* Commented OLD Processing and added the lines below for WF_HOLS ER (bug 6449458)*/

Line 7541: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

7537: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7538: )
7539: IS
7540: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
7541: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
7542: l_hold_release_rec OE_HOLDS_PVT.hold_release_rec_type;
7543: l_hold_release_id oe_hold_releases.HOLD_RELEASE_ID%type;
7544: l_api_name CONSTANT VARCHAR2(30) := 'process_create_holds';
7545: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;

Line 7782: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE

7778: /* This procedure gets called when Release Source button is pressed
7779: from the Release Source window.
7780: */
7781: procedure process_release_source(
7782: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
7783: ,p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type
7784: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
7785: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
7786: ,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 7796: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

7792: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
7793: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
7794: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
7795: --ER#7479609 l_hold_entity_code varchar2(1); /* Added for Bug 1946783 */
7796: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609
7797: l_msg_token VARCHAR2(100);
7798: BEGIN
7799:
7800: BEGIN

Line 7803: from OE_HOLD_SOURCES_all

7799:
7800: BEGIN
7801: select hold_id, hold_entity_code
7802: into l_hold_id, l_hold_entity_code
7803: from OE_HOLD_SOURCES_all
7804: where hold_source_id = p_hold_source_id;
7805: EXCEPTION
7806: WHEN NO_DATA_FOUND THEN
7807: null;

Line 8374: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE

8370: x_return_status Return status
8371: */
8372:
8373: procedure process_release_source(
8374: p_hold_source_id IN OE_Hold_Sources_ALL.HOLD_SOURCE_ID%TYPE
8375: ,p_hold_release_rec IN OE_HOLDS_PVT.Hold_Release_Rec_Type
8376: ,p_wf_release_action IN VARCHAR2
8377: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
8378: ,x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 8389: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609

8385: l_hold_id OE_HOLD_DEFINITIONS.HOLD_ID%TYPE;
8386: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE := FND_GLOBAL.RESP_APPL_ID;
8387: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE := FND_GLOBAL.RESP_ID;
8388: --ER#7479609 l_hold_entity_code VARCHAR2(1); /* Added for Bug 1946783 */
8389: l_hold_entity_code OE_HOLD_SOURCES_ALL.HOLD_ENTITY_CODE%TYPE; --ER#7479609
8390: l_msg_token VARCHAR2(100);
8391: BEGIN
8392:
8393:

Line 8397: from OE_HOLD_SOURCES_all

8393:
8394: BEGIN
8395: select hold_id, hold_entity_code
8396: into l_hold_id, l_hold_entity_code
8397: from OE_HOLD_SOURCES_all
8398: where hold_source_id = p_hold_source_id;
8399: EXCEPTION
8400: WHEN NO_DATA_FOUND THEN
8401: null;

Line 8566: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

8562: l_org_id NUMBER;
8563: l_api_name CONSTANT VARCHAR2(30) := 'SPLIT_HOLD';
8564:
8565: l_line_number NUMBER;
8566: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
8567: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8568:
8569: CURSOR c_order_holds IS
8570: SELECT oh.HOLD_SOURCE_ID

Line 8594: OE_HOLD_SOURCES_all hs

8590: , hs.ATTRIBUTE14
8591: , hs.ATTRIBUTE15
8592: , oh.org_id
8593: FROM OE_ORDER_HOLDS_all oh,
8594: OE_HOLD_SOURCES_all hs
8595: WHERE oh.line_id = p_split_from_line_id
8596: AND oh.RELEASED_FLAG = 'N'
8597: AND OH.HOLD_SOURCE_ID = HS.HOLD_SOURCE_ID;
8598:

Line 8730: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;

8726: l_application_id OE_HOLD_AUTHORIZATIONS.APPLICATION_ID%TYPE :=
8727: FND_GLOBAL.RESP_APPL_ID;
8728: l_resp_id OE_HOLD_AUTHORIZATIONS.RESPONSIBILITY_ID%TYPE
8729: := FND_GLOBAL.RESP_ID;
8730: l_hold_source_id OE_HOLD_SOURCES_ALL.HOLD_SOURCE_ID%TYPE;
8731: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
8732: l_hold_exists VARCHAR2(1) :='N'; --bug 5548778
8733: l_msg_token VARCHAR2(100); --8477694
8734:

Line 8969: oe_hold_sources_all ohs,

8965: SELECT 'Y'
8966: FROM DUAL
8967: WHERE EXISTS (SELECT NULL
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

Line 8988: oe_hold_sources_all ohs,

8984: SELECT 'Y'
8985: FROM DUAL
8986: WHERE EXISTS (SELECT NULL
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

Line 9006: FROM oe_hold_sources_all ohs,

9002: CURSOR check_src_hold_type_cur(p_hld_src_id IN NUMBER) IS
9003: SELECT 'Y'
9004: FROM DUAL
9005: WHERE EXISTS (SELECT NULL
9006: FROM oe_hold_sources_all ohs,
9007: oe_hold_definitions ohd
9008: WHERE ohd.hold_id = ohs.hold_id
9009: AND ohs.org_id = p_org_id
9010: AND ohs.hold_source_id = p_hld_src_id);