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_CREDIT_CHECK_LINES_PVT dependencies on OE_ORDER_HOLDS

Line 719: FROM OE_ORDER_HOLDS h,

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

Line 735: FROM OE_ORDER_HOLDS h,

731: ORDER BY ohr.creation_date DESC;
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

Line 778: FROM OE_ORDER_HOLDS h,

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

Line 806: FROM OE_ORDER_HOLDS h,

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

Line 3174: FROM OE_ORDER_HOLDS_all h,

3170: -- To retrieve the credit profile level of the latest manually released hold.
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

Line 3193: FROM OE_ORDER_HOLDS_all h,

3189: --13706069 start
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

Line 4281: FROM oe_order_holds_all oh,

4277: OR l.payment_type_code IS NULL
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

Line 4294: FROM OE_ORDER_HOLDS_ALL OOH,

4290: --ER 12363706 start
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