APPS.OE_CANSRV dependencies on SO_ORDER_HOLDS

Line 799: SO_ORDER_HOLDS OESOH

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
803: AND OESOH.LINE_ID IS NOT NULL

Line 849: UPDATE SO_ORDER_HOLDS

845: LOOP_HOLD_ENTITY_ID,
846: LOOP_HOLD_ENTITY_CODE,
847: 'CANCELLATION');
848:
849: UPDATE SO_ORDER_HOLDS
850: SET HOLD_RELEASE_ID = V_HOLD_RELEASE_ID,
851: LAST_UPDATE_DATE = SYSDATE,
852: LAST_UPDATED_BY = V_USER_ID,
853: LAST_UPDATE_LOGIN = V_LOGIN_ID

Line 873: FROM SO_ORDER_HOLDS SOH

869: AND HOLD_ENTITY_ID = V_HEADER_ID
870: AND HOLD_ID < 1000
871: AND NOT EXISTS
872: (SELECT 'EXISTS'
873: FROM SO_ORDER_HOLDS SOH
874: WHERE HOLD_RELEASE_ID IS NULL
875: AND SOH.HOLD_SOURCE_ID = SHS.HOLD_SOURCE_ID);
876: END HOLDS;
877:

Line 909: SO_ORDER_HOLDS OESOH

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
913: AND OESOH.HEADER_ID = V_HEADER_ID;

Line 951: UPDATE SO_ORDER_HOLDS

947: LOOP_HOLD_ENTITY_ID,
948: LOOP_HOLD_ENTITY_CODE,
949: 'CANCELLATION');
950:
951: UPDATE SO_ORDER_HOLDS
952: SET HOLD_RELEASE_ID = V_HOLD_RELEASE_ID,
953: LAST_UPDATE_DATE = SYSDATE,
954: LAST_UPDATED_BY = V_USER_ID,
955: LAST_UPDATE_LOGIN= V_LOGIN_ID

Line 975: FROM SO_ORDER_HOLDS SOH

971: AND HOLD_ENTITY_ID = V_HEADER_ID
972: AND HOLD_ID < 1000
973: AND NOT EXISTS
974: (SELECT 'EXISTS'
975: FROM SO_ORDER_HOLDS SOH
976: WHERE HOLD_RELEASE_ID IS NULL
977: AND SOH.HOLD_SOURCE_ID = SHS.HOLD_SOURCE_ID);
978: END ALL_HOLDS;
979: