Product: | WSH - Shipping Execution |
---|---|
Description: | |
Implementation/DBA Data: | APPS.WSH_SHIP_CONFIRM_RULES_V |
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