APPS.OE_CANSRV dependencies on SO_HOLD_SOURCES

Line 798: FROM SO_HOLD_SOURCES OESRC,

794: OESRC.HOLD_SOURCE_ID HOLD_SOURCE_ID,
795: OESRC.HOLD_ENTITY_ID HOLD_ENTITY_ID,
796: OESRC.HOLD_ENTITY_CODE HOLD_ENTITY_CODE,
797: OESOH.ORDER_HOLD_ID ORDER_HOLD_ID
798: FROM SO_HOLD_SOURCES OESRC,
799: SO_ORDER_HOLDS OESOH
800: WHERE OESRC.HOLD_SOURCE_ID = OESOH.HOLD_SOURCE_ID
801: AND OESRC.RELEASED_FLAG = 'N'
802: AND OESOH.HOLD_RELEASE_ID IS NULL

Line 862: UPDATE SO_HOLD_SOURCES SHS

858:
859: -- Release automatically applied source holds(with hold_id < 1000) when
860: -- all the underline order holds have been released.
861:
862: UPDATE SO_HOLD_SOURCES SHS
863: SET RELEASED_FLAG = 'Y',
864: LAST_UPDATE_DATE = SYSDATE,
865: LAST_UPDATED_BY = V_USER_ID,
866: LAST_UPDATE_LOGIN = V_LOGIN_ID

Line 908: FROM SO_HOLD_SOURCES OESRC,

904: OESRC.HOLD_SOURCE_ID HOLD_SOURCE_ID,
905: OESRC.HOLD_ENTITY_ID HOLD_ENTITY_ID,
906: OESRC.HOLD_ENTITY_CODE HOLD_ENTITY_CODE,
907: OESOH.ORDER_HOLD_ID ORDER_HOLD_ID
908: FROM SO_HOLD_SOURCES OESRC,
909: SO_ORDER_HOLDS OESOH
910: WHERE OESRC.HOLD_SOURCE_ID = OESOH.HOLD_SOURCE_ID
911: AND OESRC.RELEASED_FLAG = 'N'
912: AND OESOH.HOLD_RELEASE_ID IS NULL

Line 964: UPDATE SO_HOLD_SOURCES SHS

960:
961: -- Release automatically applied source holds(with hold_id < 1000) when
962: -- all the underline order holds have been released.
963:
964: UPDATE SO_HOLD_SOURCES SHS
965: SET RELEASED_FLAG = 'Y',
966: LAST_UPDATE_DATE = SYSDATE,
967: LAST_UPDATED_BY = V_USER_ID,
968: LAST_UPDATE_LOGIN= V_LOGIN_ID