APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_HOLD_SOURCES_ALL

Line 720: OE_HOLD_SOURCES_ALL s,

716: --added for BUG#9728597 Start
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

Line 736: OE_HOLD_SOURCES_ALL s,

732:
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

Line 779: OE_HOLD_SOURCES_ALL s

775: --commented for BUG#9728597
776: /*SELECT /* MOAC_SQL_CHANGE */ /*NVL(MAX(H.HOLD_RELEASE_ID),0)
777: INTO l_hold_release_id
778: FROM OE_ORDER_HOLDS h,
779: OE_HOLD_SOURCES_ALL s
780: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
781: AND H.HEADER_ID = p_header_id
782: AND H.LINE_ID IS NULL
783: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 807: OE_HOLD_SOURCES_ALL s

803: --commented for BUG#9728597
804: /*SELECT /* MOAC_SQL_CHANGE */ /*NVL(MAX(H.HOLD_RELEASE_ID),0)
805: INTO l_hold_release_id
806: FROM OE_ORDER_HOLDS h,
807: OE_HOLD_SOURCES_ALL s
808: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
809: AND H.HEADER_ID = p_header_id
810: AND H.LINE_ID = p_line_id
811: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 1925: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609

1921: )
1922: IS
1923:
1924: --ER#7479609 l_hold_entity_id NUMBER := p_header_id;
1925: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609
1926: l_hold_id NUMBER;
1927: l_hold_exists VARCHAR2(1);
1928: l_hold_result VARCHAR2(30);
1929: l_msg_count NUMBER := 0;

Line 2140: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609

2136: , x_cc_result_out OUT NOCOPY VARCHAR2
2137: )
2138: IS
2139: --ER#7479609 l_hold_entity_id NUMBER := p_header_id;
2140: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609
2141: l_hold_id NUMBER;
2142: l_hold_exists VARCHAR2(1);
2143: l_hold_result VARCHAR2(30);
2144: l_msg_count NUMBER := 0;

Line 3175: OE_HOLD_SOURCES_ALL s,

3171: CURSOR released_hold
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

Line 3194: OE_HOLD_SOURCES_ALL s,

3190: CURSOR released_hold_line(p_line_id IN NUMBER)
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

Line 4282: oe_hold_sources_all hs

4278: )
4279: AND (EXISTS
4280: (SELECT 'Y'
4281: FROM oe_order_holds_all oh,
4282: oe_hold_sources_all hs
4283: WHERE oh.header_id = p_header_rec.header_id
4284: AND oh.line_id = l.line_id
4285: AND oh.hold_release_id IS NULL
4286: AND oh.hold_source_id = hs.hold_source_id

Line 4295: OE_HOLD_SOURCES_ALL OHS

4291:
4292: CURSOR latest_hold_rec(p_header_id IN NUMBER) IS
4293: SELECT OHS.HOLD_SOURCE_ID
4294: FROM OE_ORDER_HOLDS_ALL OOH,
4295: OE_HOLD_SOURCES_ALL OHS
4296: WHERE OOH.HOLD_SOURCE_ID = OHS.HOLD_SOURCE_ID
4297: AND OOH.HEADER_ID = p_header_id
4298: AND OHS.HOLD_ID = 1
4299: ORDER BY OOH.last_update_date DESC;