APPS.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_HOLD_SOURCES_ALL

Line 679: OE_HOLD_SOURCES_ALL s

675: THEN
676: SELECT /* MOAC_SQL_CHANGE */ NVL(MAX(H.HOLD_RELEASE_ID),0)
677: INTO l_hold_release_id
678: FROM OE_ORDER_HOLDS h,
679: OE_HOLD_SOURCES_ALL s
680: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
681: AND H.HEADER_ID = p_header_id
682: AND H.LINE_ID IS NULL
683: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 692: OE_HOLD_SOURCES_ALL s

688: ELSE
689: SELECT /* MOAC_SQL_CHANGE */ NVL(MAX(H.HOLD_RELEASE_ID),0)
690: INTO l_hold_release_id
691: FROM OE_ORDER_HOLDS h,
692: OE_HOLD_SOURCES_ALL s
693: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
694: AND H.HEADER_ID = p_header_id
695: AND H.LINE_ID = p_line_id
696: AND H.HOLD_RELEASE_ID IS NOT NULL

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

1763: )
1764: IS
1765:
1766: --ER#7479609 l_hold_entity_id NUMBER := p_header_id;
1767: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609
1768: l_hold_id NUMBER;
1769: l_hold_exists VARCHAR2(1);
1770: l_hold_result VARCHAR2(30);
1771: l_msg_count NUMBER := 0;

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

1978: , x_cc_result_out OUT NOCOPY VARCHAR2
1979: )
1980: IS
1981: --ER#7479609 l_hold_entity_id NUMBER := p_header_id;
1982: l_hold_entity_id oe_hold_sources_all.hold_entity_id%TYPE := p_header_id; --ER#7479609
1983: l_hold_id NUMBER;
1984: l_hold_exists VARCHAR2(1);
1985: l_hold_result VARCHAR2(30);
1986: l_msg_count NUMBER := 0;

Line 3858: oe_hold_sources_all hs

3854: )
3855: AND (EXISTS
3856: (SELECT 'Y'
3857: FROM oe_order_holds_all oh,
3858: oe_hold_sources_all hs
3859: WHERE oh.header_id = p_header_rec.header_id
3860: AND oh.line_id = l.line_id
3861: AND oh.hold_release_id IS NULL
3862: AND oh.hold_source_id = hs.hold_source_id