VIEW: APPS.WSH_SHIP_CONFIRM_RULES_V

Source

View Text - Preformatted

SELECT SCR.SHIP_CONFIRM_RULE_ID, SCR.ROWID, SCR.EFFECTIVE_START_DATE, SCR.NAME, SCR.EFFECTIVE_END_DATE, SCR.ACTION_FLAG, DECODE(SCR.ACTION_FLAG, 'B', 'S', 'T', 'S', 'L', 'S', SCR.ACTION_FLAG), DECODE(SCR.ACTION_FLAG, 'A', 'S', 'C', 'S', 'O', 'S', SCR.ACTION_FLAG), SCR.STAGE_DEL_FLAG, SCR.SHIP_METHOD_DEFAULT_FLAG, LV.MEANING, SCR.SHIP_METHOD_CODE, SCR.AC_ACTUAL_DEP_DATE_DEFAULT, SCR.AC_INTRANSIT_FLAG, SCR.AC_CLOSE_TRIP_FLAG, SCR.AC_BOL_FLAG, SCR.AC_DEFER_INTERFACE_FLAG, SCR.MC_INTRANSIT_FLAG, SCR.MC_CLOSE_TRIP_FLAG, SCR.MC_DEFER_INTERFACE_FLAG, RS.NAME, SCR.REPORT_SET_ID, SCR.SEND_945_FLAG, SCR.CREATION_DATE, SCR.CREATED_BY, SCR.LAST_UPDATED_BY, SCR.LAST_UPDATE_DATE, SCR.MC_BOL_FLAG FROM WSH_SHIP_CONFIRM_RULES SCR, WSH_REPORT_SETS RS, FND_LOOKUP_VALUES_VL LV WHERE SCR.SHIP_METHOD_CODE = LV.LOOKUP_CODE(+) AND LV.LOOKUP_TYPE(+) = 'SHIP_METHOD' AND LV.VIEW_APPLICATION_ID(+) = 3 AND RS.REPORT_SET_ID(+) = SCR.REPORT_SET_ID

View Text - HTML Formatted

SELECT SCR.SHIP_CONFIRM_RULE_ID
, SCR.ROWID
, SCR.EFFECTIVE_START_DATE
, SCR.NAME
, SCR.EFFECTIVE_END_DATE
, SCR.ACTION_FLAG
, DECODE(SCR.ACTION_FLAG
, 'B'
, 'S'
, 'T'
, 'S'
, 'L'
, 'S'
, SCR.ACTION_FLAG)
, DECODE(SCR.ACTION_FLAG
, 'A'
, 'S'
, 'C'
, 'S'
, 'O'
, 'S'
, SCR.ACTION_FLAG)
, SCR.STAGE_DEL_FLAG
, SCR.SHIP_METHOD_DEFAULT_FLAG
, LV.MEANING
, SCR.SHIP_METHOD_CODE
, SCR.AC_ACTUAL_DEP_DATE_DEFAULT
, SCR.AC_INTRANSIT_FLAG
, SCR.AC_CLOSE_TRIP_FLAG
, SCR.AC_BOL_FLAG
, SCR.AC_DEFER_INTERFACE_FLAG
, SCR.MC_INTRANSIT_FLAG
, SCR.MC_CLOSE_TRIP_FLAG
, SCR.MC_DEFER_INTERFACE_FLAG
, RS.NAME
, SCR.REPORT_SET_ID
, SCR.SEND_945_FLAG
, SCR.CREATION_DATE
, SCR.CREATED_BY
, SCR.LAST_UPDATED_BY
, SCR.LAST_UPDATE_DATE
, SCR.MC_BOL_FLAG
FROM WSH_SHIP_CONFIRM_RULES SCR
, WSH_REPORT_SETS RS
, FND_LOOKUP_VALUES_VL LV
WHERE SCR.SHIP_METHOD_CODE = LV.LOOKUP_CODE(+)
AND LV.LOOKUP_TYPE(+) = 'SHIP_METHOD'
AND LV.VIEW_APPLICATION_ID(+) = 3
AND RS.REPORT_SET_ID(+) = SCR.REPORT_SET_ID