VIEW: APPS.OEFV_ORDER_HOLDS

Source

View Text - Preformatted

SELECT HEADER.ORDER_NUMBER, '_LA:RELEASE.RELEASE_REASON_CODE:OE_LOOKUPS:RELEASE_REASON:MEANING', ORDHOLD.ORDER_HOLD_ID , ORDHOLD.HOLD_SOURCE_ID , ORDHOLD.HOLD_RELEASE_ID , ORDHOLD.HEADER_ID , ORDHOLD.LINE_ID , ORDHOLD.ORG_ID , '_LA:SRC.HOLD_ENTITY_CODE:OE_LOOKUPS:HOLD_ENTITY_TYPE:MEANING', SRC.HOLD_ENTITY_ID, ORDHOLD.LAST_UPDATE_DATE , ORDHOLD.LAST_UPDATED_BY , ORDHOLD.CREATION_DATE , ORDHOLD.CREATED_BY FROM OE_ORDER_HOLDS_ALL ORDHOLD , OE_HOLD_SOURCES_ALL SRC , OE_ORDER_HEADERS_ALL HEADER , OE_HOLD_RELEASES RELEASE, MTL_PARAMETERS PARA WHERE ORDHOLD.HEADER_ID = HEADER.HEADER_ID AND ORDHOLD.HOLD_SOURCE_ID = SRC.HOLD_SOURCE_ID AND ORDHOLD.ORG_ID = PARA.ORGANIZATION_ID(+) AND ORDHOLD.HOLD_RELEASE_ID = RELEASE.HOLD_RELEASE_ID(+) AND '_SEC:ORDHOLD.ORG_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT HEADER.ORDER_NUMBER
, '_LA:RELEASE.RELEASE_REASON_CODE:OE_LOOKUPS:RELEASE_REASON:MEANING'
, ORDHOLD.ORDER_HOLD_ID
, ORDHOLD.HOLD_SOURCE_ID
, ORDHOLD.HOLD_RELEASE_ID
, ORDHOLD.HEADER_ID
, ORDHOLD.LINE_ID
, ORDHOLD.ORG_ID
, '_LA:SRC.HOLD_ENTITY_CODE:OE_LOOKUPS:HOLD_ENTITY_TYPE:MEANING'
, SRC.HOLD_ENTITY_ID
, ORDHOLD.LAST_UPDATE_DATE
, ORDHOLD.LAST_UPDATED_BY
, ORDHOLD.CREATION_DATE
, ORDHOLD.CREATED_BY
FROM OE_ORDER_HOLDS_ALL ORDHOLD
, OE_HOLD_SOURCES_ALL SRC
, OE_ORDER_HEADERS_ALL HEADER
, OE_HOLD_RELEASES RELEASE
, MTL_PARAMETERS PARA
WHERE ORDHOLD.HEADER_ID = HEADER.HEADER_ID
AND ORDHOLD.HOLD_SOURCE_ID = SRC.HOLD_SOURCE_ID
AND ORDHOLD.ORG_ID = PARA.ORGANIZATION_ID(+)
AND ORDHOLD.HOLD_RELEASE_ID = RELEASE.HOLD_RELEASE_ID(+)
AND '_SEC:ORDHOLD.ORG_ID' IS NOT NULL WITH READ ONLY