VIEW: APPS.MST_PLAN_PARAMETERS_V

Source

View Text - Preformatted

SELECT p.ROWID, PLAN_ID, PLAN_TYPE, COMPILE_DESIGNATOR, p.DESCRIPTION, p.START_DATE, CUTOFF_DATE, PLAN_START_DATE, PLAN_COMPLETION_DATE, DATA_START_DATE, DATA_COMPLETION_DATE, OUTSIDE_PROCESSING_FLAG, DROP_SHIPMENT_FLAG, SHIP_FROM_SUPPLIER_FLAG, SHIP_TO_CUSTOMER_FLAG, RETURN_TO_SUPPLIER_FLAG, RETURN_FROM_CUSTOMER_FLAG, INT_INBOUND_ALL_FLAG, INT_OUTBOUND_ALL_FLAG, EXT_OUTBOUND_ALL_FLAG, EXT_INBOUND_ALL_FLAG, OPTIMIZATION_STRATEGY_FLAG, POOLING_FLAG, MULTI_STOP_TL_FLAG, CONTINUOUS_MOVE_FLAG, RELEASE_RUNNING_FLAG, ENGINE_ACTIVE_FLAG, OPTIMIZED_FLAG, PALLETIZE_FLAG, TARGET_TL_UTILIZATION, MIN_TL_UTILIZATION, LOCAL_POOLING_SHIPMENT_SIZE, LOCAL_POOLING_RADIUS, STOP_NEIGHBORHOOD_RADIUS, GENERAL_POOLING_RADIUS, POOL_POINT_COUNT, LOADING_UNLOADING_CHARGE, LAYOVER_CHARGES, ORIGIN_DESTINATION_TL_CHRGS, OTHER_TL_CHARGES, OTHER_LTL_CHARGES, OTHER_PARCEL_CHARGES, LTL_DISCOUNT, PARCEL_DISCOUNT, AUTO_RELEASE, AUTO_REL_RULE_SET_ID, COMMITMENT_SET_ID, CURRENCY_UOM, DISTANCE_UOM, TIME_UOM, VOLUME_UOM, WEIGHT_UOM, p.CREATED_BY, p.CREATION_DATE, p.LAST_UPDATED_BY, p.LAST_UPDATE_DATE, p.LAST_UPDATE_LOGIN, TOTAL_LTL_PIECES, REQUEST_ID, g.name, g.description, r.name, p.maximum_empty_leg_length, p.system_date_offset, p.plan_days from mst_plans p, fte_sel_groups g, MST_AUTO_REL_RULE_SETS r WHERE p.commitment_set_id = g.group_id (+) and p.AUTO_REL_RULE_SET_ID = r.rule_set_id (+)

View Text - HTML Formatted

SELECT P.ROWID
, PLAN_ID
, PLAN_TYPE
, COMPILE_DESIGNATOR
, P.DESCRIPTION
, P.START_DATE
, CUTOFF_DATE
, PLAN_START_DATE
, PLAN_COMPLETION_DATE
, DATA_START_DATE
, DATA_COMPLETION_DATE
, OUTSIDE_PROCESSING_FLAG
, DROP_SHIPMENT_FLAG
, SHIP_FROM_SUPPLIER_FLAG
, SHIP_TO_CUSTOMER_FLAG
, RETURN_TO_SUPPLIER_FLAG
, RETURN_FROM_CUSTOMER_FLAG
, INT_INBOUND_ALL_FLAG
, INT_OUTBOUND_ALL_FLAG
, EXT_OUTBOUND_ALL_FLAG
, EXT_INBOUND_ALL_FLAG
, OPTIMIZATION_STRATEGY_FLAG
, POOLING_FLAG
, MULTI_STOP_TL_FLAG
, CONTINUOUS_MOVE_FLAG
, RELEASE_RUNNING_FLAG
, ENGINE_ACTIVE_FLAG
, OPTIMIZED_FLAG
, PALLETIZE_FLAG
, TARGET_TL_UTILIZATION
, MIN_TL_UTILIZATION
, LOCAL_POOLING_SHIPMENT_SIZE
, LOCAL_POOLING_RADIUS
, STOP_NEIGHBORHOOD_RADIUS
, GENERAL_POOLING_RADIUS
, POOL_POINT_COUNT
, LOADING_UNLOADING_CHARGE
, LAYOVER_CHARGES
, ORIGIN_DESTINATION_TL_CHRGS
, OTHER_TL_CHARGES
, OTHER_LTL_CHARGES
, OTHER_PARCEL_CHARGES
, LTL_DISCOUNT
, PARCEL_DISCOUNT
, AUTO_RELEASE
, AUTO_REL_RULE_SET_ID
, COMMITMENT_SET_ID
, CURRENCY_UOM
, DISTANCE_UOM
, TIME_UOM
, VOLUME_UOM
, WEIGHT_UOM
, P.CREATED_BY
, P.CREATION_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATE_LOGIN
, TOTAL_LTL_PIECES
, REQUEST_ID
, G.NAME
, G.DESCRIPTION
, R.NAME
, P.MAXIMUM_EMPTY_LEG_LENGTH
, P.SYSTEM_DATE_OFFSET
, P.PLAN_DAYS
FROM MST_PLANS P
, FTE_SEL_GROUPS G
, MST_AUTO_REL_RULE_SETS R
WHERE P.COMMITMENT_SET_ID = G.GROUP_ID (+)
AND P.AUTO_REL_RULE_SET_ID = R.RULE_SET_ID (+)