APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_HOLD_RELEASES

Line 721: oe_hold_releases ohr

717: cursor released_hold is
718: SELECT ohr.HOLD_RELEASE_ID
719: FROM OE_ORDER_HOLDS h,
720: OE_HOLD_SOURCES_ALL s,
721: oe_hold_releases ohr
722: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
723: AND H.HEADER_ID = p_header_id
724: AND H.LINE_ID IS NULL
725: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 737: oe_hold_releases ohr

733: cursor released_hold_line is
734: SELECT ohr.HOLD_RELEASE_ID
735: FROM OE_ORDER_HOLDS h,
736: OE_HOLD_SOURCES_ALL s,
737: oe_hold_releases ohr
738: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
739: AND H.HEADER_ID = p_header_id
740: AND H.LINE_ID = p_line_id
741: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 847: FROM OE_HOLD_RELEASES

843: , CREATION_DATE -----added
844: INTO
845: l_manual_hold_exists
846: , l_release_date
847: FROM OE_HOLD_RELEASES
848: WHERE HOLD_RELEASE_ID = l_hold_release_id
849: AND RELEASE_REASON_CODE <> 'PASS_CREDIT'
850: AND CREATED_BY <> 1;
851: IF NVL(OE_credit_engine_GRP.G_delayed_request, FND_API.G_FALSE ) = FND_API.G_FALSE THEN --ER 12363706

Line 3176: oe_hold_releases ohr

3172: IS
3173: SELECT Credit_Profile_Level
3174: FROM OE_ORDER_HOLDS_all h,
3175: OE_HOLD_SOURCES_ALL s,
3176: oe_hold_releases ohr
3177: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
3178: AND H.HEADER_ID = p_header_rec.header_id
3179: AND H.LINE_ID IS NULL
3180: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 3195: oe_hold_releases ohr

3191: IS
3192: SELECT Credit_Profile_Level
3193: FROM OE_ORDER_HOLDS_all h,
3194: OE_HOLD_SOURCES_ALL s,
3195: oe_hold_releases ohr
3196: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
3197: AND H.HEADER_ID = p_header_rec.header_id
3198: AND H.LINE_ID = p_line_id
3199: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 4242: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;

4238:
4239: --ER 12363706 start
4240: l_manual_hold_exists VARCHAR2(1) := 'N';
4241: l_hold_source_id NUMBER;
4242: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;
4243: l_created_by OE_HOLD_RELEASES.CREATED_BY%TYPE;
4244: --ER 12363706 end
4245:
4246:

Line 4243: l_created_by OE_HOLD_RELEASES.CREATED_BY%TYPE;

4239: --ER 12363706 start
4240: l_manual_hold_exists VARCHAR2(1) := 'N';
4241: l_hold_source_id NUMBER;
4242: l_release_reason_code OE_HOLD_RELEASES.RELEASE_REASON_CODE%TYPE;
4243: l_created_by OE_HOLD_RELEASES.CREATED_BY%TYPE;
4244: --ER 12363706 end
4245:
4246:
4247: CURSOR cust_and_site_csr IS

Line 4447: FROM OE_HOLD_RELEASES

4443:
4444: BEGIN
4445: SELECT RELEASE_REASON_CODE,CREATED_BY
4446: INTO l_release_reason_code,l_created_by
4447: FROM OE_HOLD_RELEASES
4448: WHERE HOLD_SOURCE_ID = l_hold_source_id;
4449:
4450: IF G_debug_flag = 'Y'
4451: THEN